Forum Discussion

DiePic's avatar
DiePic
Icon for Resolver II rankResolver II
3 years ago
Solved

Help with DISTINCTCOUNT multiple filters

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

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
    DiePic
    Icon for Resolver II rankResolver II
    3 years ago

    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?