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.

     

     

Anonymous's avatar
Anonymous
Not applicable
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.