count unique value based on filtred measure

[Ibrahim_ABDUL]

Hi Everyone,

I have un problem with a count measure.  I want to count a unique number of clients who have  a calculated measure R/O>=100%.

I apply this formules:  

test = COUNTX(DISTINCT('CAL Customer'[Customer_CIP]),[R/O UL]>=100)

but its return me an error message.

Please heeeellpp

Kind regard,

Ibrahim 

PS: Sorry if my english is bad, im for France.

[Anonymous]

Hi @Ibrahim_ABDUL ,

Please try below dax formula:

measure =
VAR tmp =
    CALCULATETABLE (
        VALUES ( 'CAL Customer'[Customer_CIP] ),
        FILTER ( ALL ( 'CAL Customer' ), 'CAL Customer'[R/O UL] >= 1 )
    )
VAR val =
    COUNTROWS ( tmp )
RETURN
    val

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.

[Ibrahim_ABDUL]

Tanks alot @Anonymous 

But its doesn't work 😕. Its because the R/O UL its not a column, its an calculated measure, and i put it in a "formulas" table

and when i replace it in your formula, it give me that:

Thanks again for your help!

Kind regards,

Ibrahim

[Anonymous]

Hi @Ibrahim_ABDUL ,

Could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?  It is very helpful for me to test.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu