Forum Discussion

DataMinion's avatar
DataMinion
Icon for Helper I rankHelper I
3 years ago

Count with OR Condition

Hi,   I'm new to using Power BI so looking for help please on a problem I can't resolve.   I'm trying to count whether client 1 or client 2 is active, these clients are related and usually partne...
MarkLaf's avatar
MarkLaf
Icon for Super User rankSuper User
3 years ago

So, with the above dummy data, should ActiveClients output to 4 or 5 (because, although Bruce has 0 fee, he still counts if you factor in joint client fee/status)?

DataMinion's avatar
DataMinion
Icon for Helper I rankHelper I
3 years ago

Hi,

 

It still does not show them as Active, it is the 2nd client with the fee income and because client 1 fee income, in this case Bruce, is 0 then both the clients are not counted.

We need a way to count both clients income.

I've added columns now in the clients table by merging Clients and Income in Power Query, this now shows the income for each client and I used a measure to sum the income. The screenshot below shows their joint income to be £2,090 but as Bruce income is O the result of the measure is still blank where I would expect a 1

 

 

Ideally I dont want to merge tables as that seems slower than using measures but I just wanted to show that the end result is the same.