Forum Discussion
Rankx value changed when drill down
hello all, I have been stuck on something for a while. Your help would be appreciated. My data model is simple with one user dimention table and on fact tale holds the qty of user. There are sli...
Anonymous
I used the total Qty and the result didn't change.
Hi Anonymous ,
Not sure what is the issue.
Mine is working fine.
Total Quantity = sum('Table'[Qty])
Category Rank =
RANKX(
ALL('Table'[usr], 'Table'[grp]),
CALCULATE(SUM('Table'[Qty]))
)
Regards,
Harsh Nathani