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 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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI yash14vashistha,

     

    Can you please provide the pbix file for test?

     

    Regards,

    Xiaoxin Sheng

    • yash14vashistha's avatar
      yash14vashistha
      Helper III

      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

        HI yash14vashistha,

         

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

         

        Regards,

        Xiaoxin Sheng