how to filter distinct condition and do calculate?

[tyan]

Hi, On the right side is my data and on the left side is the result that i am looking for.  I try to set up a filter that only count completely cancel colorway which means the brand has that color but only do with cancel, no improve/ ok

thank you so much for helping me.

[OwenAuger · Accepted solution]

Thanks @tyan 

In that case, your percentage measures can be something like:

Colorway Cancellation % =
DIVIDE ( 
    [Completely cancel coloway],
    CALCULATE ( DISTINCTCOUNT ( Data[Color] ), ALLSELECTED ( ) )
    -- ALLSELECTED seems to be what you want but you could use ALL to ignore all filters
)

[OwenAuger]

Hi @tyan 

For your first measure, you can write this:

Completely cancel coloway =
SUMX (
    SUMMARIZE ( Data, Data[Brand], Data[Color] ),
    INT ( CALCULATE ( SELECTEDVALUE ( Data[analysis] ) = "cancel" ) )
)

This measure takes each combination of Brand & Color, and counts how many of these combinations have the single distinct value of analysis = "cancel", which should be equivalent to what you are wanting to calculate.

I wasn't sure on the logic behind the denominator in your percentage measure (6 in your example). How is that defined?

Regards,

Owen

[tyan]

@OwenAuger   Hi thank you for helping me, It should be 5 instrand of 6 it is the total amount of color.  it is unique not count twice.  so  it is red, blue, green,black, pink.