powerbi - Power bi group ranking

Question

Can you help me? I want the rank to be assigned within the filtered range (filter by date). Tell me, please, what am I doing wrong? CustomerSaleIndex1 = VAR CurrentOrderDate = \'public _smsnt_delete\'[date_transaction] VAR CurrentOrderTr = \'public _smsnt_delete\'[transaction_id] VAR CurrentCustomerKey = \'public _smsnt_delete\'[card_number] RETURN RANKX(FILTER(ALLSELECTED(\'public _smsnt_delete\'); \'public _smsnt_delete\'[card_number] = CurrentCustomerKey);\'public _smsnt_delete\'[date_transaction];;ASC;Dense)

标签： powerbi

Answer 1

就过滤器功能中的分隔符而言，您在逗号分隔符“ , ”上使用分号“ ; ”

此外，您已将 CurrentOrderDate 声明为变量，为什么不使用它。另一方面，为什么还要声明 CurrentOrderTr？由于您不在函数中使用它：

CustomerSaleIndex1 = 
VAR CurrentOrderDate = 'public _smsnt_delete\'[date_transaction] 
VAR CurrentCustomerKey = 'public _smsnt_delete\'[card_number] 


RETURN 
RANKX(FILTER(ALLSELECTED('public 
_smsnt_delete\'),'public_smsnt_delete\'[card_number] = CurrentCustomerKey),
CurrentOrderDate,,ASC,Dense)

https://docs.microsoft.com/en-us/dax/rankx-function-dax