Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
HI @yash14vashistha,
Can you please provide the pbix file for test?
Regards,
Xiaoxin Sheng
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.
HI @yash14vashistha,
Maybe you can try to use similar structure fake data to create sample file and share it.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.