Total missing in measure

[AnkurSharma]

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=https%3A%2F%2Fapp.powerbi.com%2FMobileRedir... 

[Greg_Deckler]

@AnkurSharma Not sure @Anonymous 's message is 100% complete. Here is some additional information to help you understand what is likely going on. This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[AnkurSharma]

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]

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]

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 · Accepted solution]

Hi, @AnkurSharma 

Try to add another measure like:

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

Best Regards,
Community Support Team _ Eason

[Anonymous]

Hello please try 

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