Forum Discussion

139068's avatar
139068
Regular Visitor
2 years ago
Solved

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.  F...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    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.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

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

vicky_'s avatar
vicky_
Super User
2 years ago

Try something like the formula:

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