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.

ldwf's avatar
ldwf
Helper V
2 years ago

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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

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