Partner billing count

[Anonymous]

hi,

can any one help me on below issue on dax 

I need to get the partners count of biling for how many partners had done sales upto 50%,80%,100%.

I need to get the count of partners for Q1,Q2,Q,Q4 wise billing .

• I have following tables :- Sales,calender table.

please refere screenshot for required ouput

[Anonymous]

Hi @amitchandak,

I need count of partners who has done billing in current years vs last year and generated revenue upto 50%,80%,100%.

i want to find the count of 50 percent partners.

For example:

IF partners has done billing in current year and generated revenue the count of partners for 100 percent is 6067.

I have tried below dax measures

1. Total Revenue = SUM(Sales[F Net Value_CR])

2. calculated Turnover = TO upto 100% = CALCULATE([Total Revenue]* 0.10)

3. Top 100% =

VAR custcount = DISTINCTCOUNT( 'Sales'[PARTNERCODE] )

RETURN

CALCULATE (

[TO upto 100%],

KEEPFILTERS (

TOPN ( custcount, VALUES ( 'Sales'[PARTNERCODE] ),[TO upto 100%], DESC )

)

)

Im getting below output which is wrong values from above screenshot.

[Ashish_Mathur]

Hi,

Share a dummy dataset and on that dataset show the expected result.

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.