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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
139068
Regular Visitor

DAX Help

Need help with what I think is a simple DAX formula.  I have a visual that looks like this.  The count field is ia measure I defined in a DAX formula that defines the count field as either 1 or 0.  For some reason when I turn on the option to show totals for this visual, the count shows as 0

139068_0-1693312841616.png

I want to be able to sum up the count field to the country level, so that I can get a total for Argentina of 3.  Instead of showing 3, the value shows 0.  

I've tried various DAX formulas but can't get it.  The count field is a measure I define in a DAX formula that results in a value of either 1 or 0.

 

2 ACCEPTED SOLUTIONS
Ashish_Mathur
Super User
Super User

Hi,

May be your Count measure can be modified to get the correct total but since i do not know what that measure is, try this one

Measure = IF(HASONEVALUE(Data[District]),[Count],SUMX(VALUES(Data[District]),[Count]))

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

You are welcome.  If my previous reply helped, please mark that as Answer.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

May be your Count measure can be modified to get the correct total but since i do not know what that measure is, try this one

Measure = IF(HASONEVALUE(Data[District]),[Count],SUMX(VALUES(Data[District]),[Count]))

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi...Your solution did it!...thanks

You are welcome.  If my previous reply helped, please mark that as Answer.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
vicky_
Super User
Super User

Try something like the formula:

New Count = IF(HASONEVALUE(Table[District]), 
    [Count], 
    SUMX(
        ADDCOOLUMNS(
            SUMMARIZE(Table, [Country], [District]), "count measure", [Count]
        ), 
    [count measure])
)

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors