Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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
)
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
)
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
@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.
User | Count |
---|---|
25 | |
11 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
7 |