topic Re: Total missing in measure in DAX Commands and Tips

Total missing in measure

AnkurSharma — Mon, 31 Oct 2022 21:57:00 GMT

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.

Anonymous — Mon, 31 Oct 2022 22:59:20 GMT

Hello please try

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

Greg_Deckler — Mon, 31 Oct 2022 23:28:34 GMT

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 — Tue, 01 Nov 2022 14:49:02 GMT

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 — Tue, 01 Nov 2022 17:43:10 GMT

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 — Tue, 01 Nov 2022 17:50:48 GMT

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 — Tue, 08 Nov 2022 09:22:54 GMT

Try to add another measure like:

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

Best Regards,
Community Support Team _ Eason