cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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 3
Highlighted
Community Support
Community Support

Re: Distinct Count based on two measures

HI @yash14vashistha,

 

Can you please provide the pbix file for test?

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Highlighted
Helper II
Helper II

Re: Distinct Count based on two measures

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.

Highlighted
Community Support
Community Support

Re: Distinct Count based on two measures

HI @yash14vashistha,

 

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

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!