HI I have this data set
|Asset Class||Asset Model||Failure Code||Notification Number||Condition Rating||Total Risk||Work Centre|
I want to create this table
|Asset Class||Asset Model||Failure Code||Count of Notifications||Condition Rating||Median Risk||Median Risk Rank|
|a||a||1||1||10||calculate this||calculate this|
|a||a||2||1||9||calculate this||calculate this|
|a||a||2||1||8||calculate this||calculate this|
|b||b||3||3||10||calculate this||calculate this|
|c||c||4||3||5||calculate this||calculate this|
The thing is, I want to be able to have a slicer on the page and if I change the work centre it recalculates the median for the ones in that work centre and the rank as well.
Then, what I want to do is plot a scatter plot and have the rank on the x axis of a scatter plot and the total risk on the y axis for each notification and this changes when you filter on work centre.
Solved! Go to Solution.
Hi I see your formula was calculating the median risk for Asset Class. I wanted to do it for a combination of Asset Model ID & Failure Code & Condition Rating so I made a combination of those as another column then passed that through and it seemed to work. Now when I do it in my report, the median seems to be working but the rank doesnt.
I then created some measures
and then I created the rank
but for some reason the AM/FM Risk one works and I can put it in a table
But when I try and add Rank AM/FM Risk it goes blank. Can you see what I have done wrong??
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.