topic True/false measure not giving total in DAX Commands and Tips

True/false measure not giving total

ROG — Wed, 18 Jan 2023 15:18:43 GMT

Hello,

What do I need to do to have a correct total on the highlighted table? It should be 7.

Thanks!

johnt75 — Wed, 18 Jan 2023 16:52:45 GMT

You need to add up the individual values, not compute the whole thing at the aggregate level. Try

Active GA+1 = SUMX ( VALUES ( 'Table'[Sales partner code] ), IF ( [Gross Addition Daily] >= 1, 1, 0 ) )

where 'Table'[Sales partner code] is the column you are grouping by in the matrix

ROG — Wed, 18 Jan 2023 17:11:34 GMT

Thank you johnt75