Distinctcount not showing total

DAX DAX Calculations
2

Hi @RDW,
Once you have the mean, to correct its calculation in the total of the table you can create the following measure:

Total New Clients =
VAR tbl =
ADDCOLUMNS(
     VALUES( 'FactTable'[CLIENT_ID] ),
         "@NewClients", [NewClients]
)
VAR _Result = IF(
     HASONEVALUE( 'Fact Table'[CLIENT_ID] ),
     [NewClients],
     SUMX( tbl, [@NewClients] )
)

RETURN
_Result

Captura

Here is a link to @Greg’s forum post where he explains how we can correct the measure calculation in the totals.

Fix Incorrect Totals - DAX Patterns - Enterprise DNA Forum

Regards,

Enterprise DNA_JAFP.pbix (429.2 KB)