Forum Discussion
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 will be 1.
Cheers,
OscLar
Hi OscLar,
DAXPatterns have a good article, have a look at the "Mode" section here:
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
5 Replies
Hi OscLar,
DAXPatterns have a good article, have a look at the "Mode" section here:
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
Thank you both!
Cheers,
OscLar
Ahh, sorry!
New here and missed that.Fixing now.
Cheers,
