Show Total Sum as opposed to each product sales on each line in calculation

[Anonymous]

Hi Experts

I am trying to show the total sum on each line and then divide the total by the indivudal product sales. see sample data

1. I want to show in my tooltip total sales as 100 and then in the measure preform the calcultion which would be each individual product sales / total sales.

[Anonymous · Accepted solution]

Measure =

VAR Individual = SUM(Test[Sales])

VAR Total= CALCULATE(SUM(Test[2017 Sales]),ALL(Test[Category]))

RETURN DIVIDE(Individual,Total,0)

[Anonymous]

many thanks Vimal