Forum Discussion

yash14vashistha's avatar
yash14vashistha
Helper III
8 years ago

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...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI yash14vashistha,

 

Can you please provide the pbix file for test?

 

Regards,

Xiaoxin Sheng

yash14vashistha's avatar
yash14vashistha
Helper III
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

    HI yash14vashistha,

     

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

     

    Regards,

    Xiaoxin Sheng