Forum Discussion
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
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.
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.
You are welcome. If my previous reply helped, please mark that as Answer.
4 Replies
Try something like the formula:
New Count = IF(HASONEVALUE(Table[District]), [Count], SUMX( ADDCOOLUMNS( SUMMARIZE(Table, [Country], [District]), "count measure", [Count] ), [count measure]) )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.
Hi...Your solution did it!...thanks
You are welcome. If my previous reply helped, please mark that as Answer.
