Forum Discussion
Helper IIIMin/Median/Max Matrix
H,
Is it possible to have Min / Median / Max instead of the total or in another matrix? Do we have to create a measure for each statistic (Min / Median / Max) and for each variable analyzed?
Thanks
Hi Jeremy19 ,
since last update of PBID you can use external tools as Tabular Editor to create calculated groups. This could be a possible solution to avoid massive amount of measures. Take a look at this topic:
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
Regards FrankAT
5 Replies
- amitchandak
Super User
Jeremy19 , not very clear. You can use any function in a measure
https://docs.microsoft.com/en-us/dax/median-function-dax
Hi Jeremy19 ,
For MIN and MAX you can use the default aggregates in Power BI
https://docs.microsoft.com/en-us/power-bi/create-reports/service-aggregates
For Median you need to create a measure.
https://docs.microsoft.com/en-us/dax/median-function-dax
Refer these videos
https://www.youtube.com/watch?v=y1ilV9o47Z4
https://www.youtube.com/watch?v=3i-VvzI6v0c
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Jeremy19Sorry for not having was pretty clear. But I have a table by individuals with 10 variables which are therefore the sum by individuals. I would like to have online instead of the total, the median / min / max. Today I am using MINX / MEDIANX / MAXX measures for each variable (30 measures in total) but it's quite complicated as a solution. Is there another way?
- FrankAT
Community Champion
Hi Jeremy19 ,
since last update of PBID you can use external tools as Tabular Editor to create calculated groups. This could be a possible solution to avoid massive amount of measures. Take a look at this topic:
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
Regards FrankAT
- v-juanli-msft
Community Support
Hi Jeremy19
If i understand you correctly, please right click on the field.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
