Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Everyone,
I would like to create a metrix in PBI as below.
It is ok for me to create the measure about Resolved%. However, only P1-P3 Gap,# is different to realize.
My measure is:
The CALCULATE can't calculate the expression which contains multiple columns .
I need to calculate the count which "Column" = "No" and MappedPriority isn't P4-P5.
The Gap means the count of items which "Column" = "No".
Could you help me te solve this?
Thanks in advance.
Regards
Solved! Go to Solution.
Hi @Kelly_Zhu,
Please modify your measure formula to:
Measure 4 = CALCULATE ( COUNT ( OpenBacklog[Column] ), FILTER ( OpenBacklog, AND ( OpenBacklog[Column] = "No", OpenBacklog[MappedPriority] <> "P4" ) ) )
Best regards,
Yuliana Gu
I just wanted to say thanks for this solution, i'd been looking for over a day on an actual solution to filtering two specific values from two specific columns in a measure!
Hi @Kelly_Zhu,
If my priginal reply is helpful to your scenario, would you please kindly mark it as an answer? If you still have any concern, please feel free to ask.
Thanks,
Yuliana Gu
Ok. Thanks for your reminder.
Hi @Kelly_Zhu,
Please modify your measure formula to:
Measure 4 = CALCULATE ( COUNT ( OpenBacklog[Column] ), FILTER ( OpenBacklog, AND ( OpenBacklog[Column] = "No", OpenBacklog[MappedPriority] <> "P4" ) ) )
Best regards,
Yuliana Gu
Hi Yuliana,
Thanks a lot!
BTW could you help me to hide the blank column?
Thanks,
Kelly
Hi @Kelly_Zhu,
Unfortunately, there is no such a visibility property to conditionally show/hide a column in matrix. you could submit your idea on the link below: https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Yuliana Gu
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |