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

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

HI Greg 

can you help me with Hason filter on this measure?

CALCULATE(COUNTROWS('Sheet1'),FILTER('Sheet1',CONTAINSSTRING('Sheet1'[Column1],MAX(test[Company]))))

 

i tried this but not working

 

IF(HASONFILTER(

CALCULATE(COUNTROWS('Sheet1'),FILTER('Sheet1',CONTAINSSTRING('Sheet1'[Column1],MAX(test[Company]))))

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello the measure shoulf be the same so example

Measure1 = CALCULATE(countrows(sheet1),filter(sheet1,containstring(sheet1[column1],max(test[company]))

 

Then 

IF(HASONEFILTER(table[main column on your visual table]),[Measure1]

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

      Hi, AnkurSharma 

      Try to add another measure like:

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

      Best Regards,
      Community Support Team _ Eason