Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Margin % calculation with same name and multiple rows

Hi Experts, I am working on revenue margin calculation in my dashboard. But it is not giving the result as expected and it is summing the % (YTD CM% --> 45+53 = 98% for CM%) --> Data source from SP...
Selva-Salimi's avatar
Selva-Salimi
Icon for Solution Sage rankSolution Sage
1 year ago

Hi Anonymous 

 

I think you should update your DAX as follows:

 

CM % = DIVIDE(calculate([Total Actual Revenue],ALLEXCEPT('Test Delivery Updates','Test Delivery Updates'[Account Name])) , calculate([Total YTD Revenue] ,ALLEXCEPT('Test Delivery Updates','Test Delivery Updates'[Account Name])) ,0)

 

If this post helps, then I would appreciate a thumbs up  and mark it as the solution to help the other members find it more quickly.