Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
Solved! Go to 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.
@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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
73 | |
66 | |
60 |