Forum Discussion
Dynamic measure calculations using page filter
HI I have a group of notifications like this Asset Model Failure Name Condition Rating Total Risk Work Centre Notification NUmber A 1 ...
Hi there,
I think you might need your ranking to be based on a column not a table which it appears to be. I have used rankings where I am ranking countries by spend here is my formula
If(ISINSCOPE(Countries[International Short]),If(Not ISBLANK([Dynamic Spend ($M)]),RANKX(ALLSELECTED(Countries[International Short]),Combined[Dynamic Spend ($M)])))
If you want to rank by the combination of your 3 columns (asset model, failure name, condition rating) I would recommend creating a column which concatenates all 3 together and then use that where I have 'Countries[International Short]'. Replace my '[Dynamic Spend ($M)]' with your Median Total Risk.
Hope this helps.
(P.S. I am just a fellow end user so apologies if my response isn't useful)