Count distinct shows wrong grand value

[Anonymous]

Hi,

Im going through a scenario which has 21 wrows in a matrix table but showing grand total as 24.,

My measure is,

Deals =

CALCULATE (

DISTINCTCOUNT( vw_as_Deals[accountid] ),

FILTER (

new_datavalidation,

new_datavalidation[statecode_displayname] = "Completed"

&& new_datavalidation[new_checkinguser] <> BLANK ()

&& new_datavalidation[new_checkingdate] <= MAX ( vw_as_Deals[Date] )

),

FILTER ( vw_as_Deals, vw_as_Deals[Date] >= MIN( DateTable[Date] )

))

Can someone please help on this

Thanks

[amitchandak]

@Anonymous , Try like.  Change the table name of Deals as per need

Deals =
sumx(values(vw_as_Deals[Deals]) ,
CALCULATE (
DISTINCTCOUNT( vw_as_Deals[accountid] ),
FILTER (
new_datavalidation,
new_datavalidation[statecode_displayname] = "Completed"
&& new_datavalidation[new_checkinguser] <> BLANK ()
&& new_datavalidation[new_checkingdate] <= MAX ( vw_as_Deals[Date] )
),
FILTER ( vw_as_Deals, vw_as_Deals[Date] >= MIN( DateTable[Date] )
)))

[Anonymous]

@amitchandak 

Thanks for the help. But counts are not correct with this measure.