Count if two columns differ??

[Anonymous]

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

[Anonymous · Accepted solution]

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 Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.