Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 wise billing .

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

please refere screenshot for required ouput

 

 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Ashish_Mathur
      Super User
      4 years ago

      Hi,

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