Help with DISTINCTCOUNT multiple filters

[DiePic]

Hi all,

that my problem:

I've read a lot of posts for this problem, but I'm not able to find the tight solution.

can somebody indicate me where I'm mistaken?
Thanks in advance for any help or suggestion

[Anonymous · Accepted solution]

Hi @DiePic ,

Please try below steps:

1. below is my test table

Table:

2. create a measure with below dax formula

Measure =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Column2] ),
    FILTER ( ALL ( 'Table' ), LEN ( 'Table'[Column2] ) > 1 && 'Table'[Column1] = 0 )
)

3. render

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DiePic]

I try to read a lot of posts about similar cases, but I'm not able to find a solution.

Can somebody help or give a suggestion?