Forum Discussion

AnkurSharma's avatar
AnkurSharma
Icon for Helper I rankHelper I
4 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
    4 years ago

    Hi, AnkurSharma 

    Try to add another measure like:

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

    Best Regards,
    Community Support Team _ Eason

AnkurSharma's avatar
AnkurSharma
Icon for Helper I rankHelper I
4 years ago
Measure = IF(HASONEFILTER(test[Company]),CALCULATE(COUNTROWS('Sheet1'),FILTER('Sheet1',CONTAINSSTRING('Sheet1'[Column1],MAX(test[Company])))))
 
Tried but no success still no totals.

 

 

 

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, AnkurSharma 

Try to add another measure like:

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

Best Regards,
Community Support Team _ Eason