Forum Discussion
Partner billing count
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...
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.
Hi,
Share a dummy dataset and on that dataset show the expected result.