Forum Discussion

nmckbcs's avatar
nmckbcs
Icon for Helper I rankHelper I
7 years ago
Solved

Simple Average/SUMMARIZE dax function

Hello, I am using a AVERAGEX(SUMMMARIZE formulat to get an avg for a net promoter type calculation by month. I am also showing the percentage of each response and bucketing those in happy, mad, or ...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi nmckbcs,

     

    Please refer to below measure:

    AVG_Category_Breakdown2 =
SUMX ( VALUES ( 'download to use'[Month] ), [Category_Breakdown] )
    / CALCULATE (
        DISTINCTCOUNT ( 'download to use'[Month] ),
        ALL ( 'download to use' )
    )

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi nmckbcs,

 

Please refer to below measure:

AVG_Category_Breakdown2 =
SUMX ( VALUES ( 'download to use'[Month] ), [Category_Breakdown] )
    / CALCULATE (
        DISTINCTCOUNT ( 'download to use'[Month] ),
        ALL ( 'download to use' )
    )

 

Best regards,

Yuliana Gu