Power BI DAX: Rank Top N Accounts with dynamic calculated index for visual filter based on user selections
DAX Formula for Video:
Account ranking index for top N number =
Var Selected_TOP_N_Number = SELECTEDVALUE('Table for Top N Selections'[Top N])
RETURN
if(
[Account value rank Index]<=Selected_TOP_N_Number,
VALUE(1),
VALUE(0)
)
Comments
Post a Comment