Forum Discussion

TB2's avatar
TB2
New Member
2 years ago
Solved

Top 2 Contribution % calculation

Hi,    I'm trying to calculate the TopN contribution % based on Customer, Branch or Type.   Customer Branch Type Actual Budget A NY Red $50 $120 B CA Green $250 $300 C IL...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi TB2 ,

    Thank you Jihwan_Kim very much for the solution, and I've tried other ways to help you understand the problem:

    For your question, I think your last step could include an all condition to remove the context filtering.

    TOP 2 Contribution % = DIVIDE('Table'[Top 2 Customers],CALCULATE('Table'[sales revenge],ALL('Table')))

    Hope it helps!

     

    Best regards,
    Community Support Team_ Tom Shen

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

Hi,

I am not sure if I understood your question correctly, but please try something like below whether it suits your inquiry.

 

Top 2 Contribution % =
DIVIDE (
    [Top 2 Customers],
    CALCULATE ( [Sales Revenue], ALLSELECTED ( 'Customers'[Customer #] ) )
)