Forum Discussion
Distinct Count based on two measures
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...
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