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??
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.