Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
AnkurSharma
Helper I
Helper I

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. 

 

Capture.PNGhttps://emails.azure.microsoft.com/redirect/?destination=https%3A%2F%2Fapp.powerbi.com%2FMobileRedir... 

1 ACCEPTED SOLUTION

Hi, @AnkurSharma 

Try to add another measure like:

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

Best Regards,
Community Support Team _ Eason

View solution in original post

6 REPLIES 6
Greg_Deckler
Community Champion
Community Champion

@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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

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
Not applicable

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]

Measure = IF(HASONEFILTER(test[Company]),CALCULATE(COUNTROWS('Sheet1'),FILTER('Sheet1',CONTAINSSTRING('Sheet1'[Column1],MAX(test[Company])))))
 
Tried but no success still no totals.
AnkurSharma_1-1667325037325.png

 

 

 

Hi, @AnkurSharma 

Try to add another measure like:

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

Best Regards,
Community Support Team _ Eason

Anonymous
Not applicable

Hello please try 

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.