Forum Discussion

Helper I

8 years ago

Solved

Most probable value

Hi, A quick question: Is there an easy way to calculate the MPV (Most Probable Value) for a column? Let's say I have five data points: {1, 1, 1, 1, 96}. The average will be 20 but the MPV...

Tips and Tricks

JoHo_BI
8 years ago
Hi OscLar,

DAXPatterns have a good article, have a look at the "Mode" section here:

https://www.daxpatterns.com/statistical-patterns/
Greg_Deckler
8 years ago
Yes, I have some Mode measures in the Quick Measures Gallery:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Mode-Single-Column/m-p/359150
https://community.powerbi.com/t5/Quick-Measures-Gallery/Mode-Multiple-Columns/m-p/359148

Community Champion

8 years ago

Yes, I have some Mode measures in the Quick Measures Gallery:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Mode-Single-Column/m-p/359150

https://community.powerbi.com/t5/Quick-Measures-Gallery/Mode-Multiple-Columns/m-p/359148

Related content