Forum Discussion

HueySantiago's avatar
HueySantiago
New Member
4 years ago
Solved

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-...
Need Help
  • HueySantiago's avatar
    HueySantiago
    4 years ago

    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's avatar
    HueySantiago
    New Member
    4 years ago

    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's avatar
    HueySantiago
    New Member
    4 years ago

    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.