Stop distinct count blank values from multiple tables

[Dtrain]

Hi,

I am trying to stop counting blank from the DAX but can't work it out. I need help please.

Act ID =

COUNTROWS (

DISTINCT (

UNION (

DISTINCT ( 'table column A'[CreatedNo] ),

DISTINCT ( 'table column B'[ModifiedCreatedNo] )

)

))

Thanks

[AliceW]

You could use COUNTAX

[Dtrain]

COUNTAX did not work 😞

[V-lianl-msft · Accepted solution]

Try measure like below:

Act ID = 
COUNTROWS (
DISTINCT (
UNION (
DISTINCT (FILTER(VALUES('table column A'[CreatedNo]), 'table column A'[CreatedNo] <> BLANK() )),
DISTINCT ( FILTER(VALUES('table column B'[ModifiedCreatedNo]),'table column B'[ModifiedCreatedNo]<>BLANK()) )
)))

[Dtrain]

Your measure has been working well but I was just wondering if a filter can be added? I would like to see the results only Males from column C. What would be the best way to write the measure to include this?

[Dtrain]

You're a lifesaver. Thank you soon much for the help.