Forum Discussion
Solved
Question Measure - Count SUM and Exclude from other status (Total Count)
Hi Team, Have just started my PowerBi Journey, and have a Q. I have 2 Columns. KeyValue and Status KeyValue are Unique IDs Status = Pending; Exception; Completed (see table below for details) ...
I'd suggest making a new column that only includes the elements that have the uniqueness you want. I'd suggest doing this in Power Query. Then just update the provided code to work how you need it.
Thanks Ross, Your method works fine, with one slight issue (which I think I didn't explain properly because the table was confusing). the Unique ID when completed has this added ID- 111 - Review Status= Completed. So what I need to do is Compare the ID with removing the "- Review" part if it has. (sometimes it will not have that) hope this makes sense, and apologies my last table made it a bit confusing.
I'd suggest making a new column that only includes the elements that have the uniqueness you want. I'd suggest doing this in Power Query. Then just update the provided code to work how you need it.