Forum Discussion
Count if two columns differ??
Hi,
I am trying to get Power BI to use see if two coloumns differ in the same sheet.
Column 1 is 'Employment status' - it contains a list of either inactive or unemployed.
Column 2 is 'Employment staus on leaving' (My project), - it contains a list of either unemployed, Employed or inactive.
I need it to count people who have moved from inactive to unemployed?? Is this possible?
Is there a simple way to do this using filters rather than DAX? Please help 🙂
Merry Christmas!
Martin
Hi Anonymous ,
According to your statement, I think you want to count based on the filters on two columns in same table.
I think filter on 'Employment status' should be "inactive" and filter on 'Employment staus on leaving' should be "unemployed". I suggest you to show your result by a card visual with visual level filter field.
My Smaple:
Result is as below.
For reference: Add a filter to a report in Power BI - Power BI | Microsoft Learn
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
According to your statement, I think you want to count based on the filters on two columns in same table.
I think filter on 'Employment status' should be "inactive" and filter on 'Employment staus on leaving' should be "unemployed". I suggest you to show your result by a card visual with visual level filter field.
My Smaple:
Result is as below.
For reference: Add a filter to a report in Power BI - Power BI | Microsoft Learn
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.