Forum Discussion
Rank not Working
Hello All, I am working on a requirement, In this, I have created a filter of dimension from the parameter field, and I want to make it dynamic and get the rank of sales throu...
Try the following :
Rank =
RANKX(
ALL('KPI Selection'),
CALCULATE(SUM(Fact_Sales[Total Sale Qty])),
,
DESC,
DENSE
)It is showing 1 for all
