cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HueySantiago
New Member

Help undertanding NORM.S.DIST DAX Measure on a Card Visual

Hi,

 

I've been trying to understand the NORM.S.DIST DAX function and it's giving me a lot of weirdness. As far as I can understand, it would be able to give me the associated probability from a z-score, and for the most part, that seems to be true. However, I have encountered some weirdness:

 

Going by the sample in the documentation,

 

 

Measure = NORM.S.DIST (1.333333, TRUE)

 

 

Should return 0.908788725604095

 

However when I try it on my end, it returns a different value altogether. What happens is that the value is multiplied by 50. I noticed that this is due to the aggregation being SUM. Changing the aggregation to something like Average, Minimum, or Maximum seems to make it display the correct value, and the multiplication by 50 only seems to happen if the aggregation is SUM and only on Cards. Anyone know why?

 

1 ACCEPTED SOLUTION

Hi SpartaBI,

 

I think I've cracked it now. Looking over the file again, it seems I misclicked. I thought it was a Measure, but I noticed that the icon was different. What I created was actually a column. It just so happens that the sample data I used had 50 items. That was why the SUM aggregation multiplies the result by 50.

View solution in original post

3 REPLIES 3
SpartaBI
Community Champion
Community Champion

@HueySantiago have you checked this article and video in DAX GUIDE?
https://dax.guide/norm-s-dist/

Hi SpartaBI,

 

I think I've cracked it now. Looking over the file again, it seems I misclicked. I thought it was a Measure, but I noticed that the icon was different. What I created was actually a column. It just so happens that the sample data I used had 50 items. That was why the SUM aggregation multiplies the result by 50.

Hi SpartaBI,

 

Thank you for the link. Unfortunately, it didn't answer my question of why the returned value is multiplied by 50 if the Measure is placed on a card visualization and the aggregation is SUM. I am also quite new to statistics, so some terms escape me.

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors