Distinct Count based on two measures

[yash14vashistha]

Hey Guys,

I need to calculate the distinct count of clients based on the previous year's and this year's fee

Right now i am using this

CALCULATE(DISTINCTCOUNT(FV[Client (Parent)]),SUM(FV[YTD PBR less BE (USD)]) <= 0,SUM(FV[Prior 1 YTD PBR less BE (USD)]) > 0)

where 'client parent' is the column header for clients, 'PBR less be' is the fee. So YTD is this year's and Prior 1 YTD is previous year's fee.

So what I am doing here is to see the number of clients whose fee was  <= 0 (Less than) this year and > 0 (greater than) in previous year.

But this isn't working

[Anonymous]

HI @yash14vashistha,

Can you please provide the pbix file for test?

Regards,

Xiaoxin Sheng

[yash14vashistha]

Unfortunately I can't. The data is confidential. But this is exactly the same Calc I am doing. If there is some confusion I will happliy clear it.

[Anonymous]

HI @yash14vashistha,

Maybe you can try to use similar structure fake data to create sample file and share it.

Regards,

Xiaoxin Sheng