Forum Discussion

AnkurSharma's avatar
AnkurSharma
Icon for Helper I rankHelper I
3 years ago
Solved

Total missing in measure

Hi everyone,   I created one measure which shows count but it is not showing me total in the end. Thanks for your time and help.    https://emails.azure.microsoft.com/redirect/?destination=ht...
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, AnkurSharma 

    Try to add another measure like:

    Result = SUMX(VALUES(test[Company]),[Company count])

    Best Regards,
    Community Support Team _ Eason

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello please try 

Correct Total = IF(HASONEFILTER(table[main column on your visual table]),[Your Measure]