Compare every category to one category in percentages

[Esther_1999]

Hi,

I want to compare every category to the costs of soccer. The table should look like this:

Sport  Costs Percentage compared to soccer
Soccer 400 100%
Tennis 200 50%
Hockey 100 25%

Can someone help me how to get this percentage? I tried a lot of things but it does not seem to work. Thank you in advance!

[audreygerred · Accepted solution]

Hi! First, I made a measure for Total costs:

Total Costs = SUM(Table[Costs])

Next, I made a measure for the soccer costs:

Costs for Soccer =

CALCULATE([Total Costs], 'Table'[Sport] IN { "Soccer" })

Then, I created the percentage measure:

Percentage of Soccer = DIVIDE([Total Costs],[Costs for Soccer])

You can also do a percentage difference to show how much lower each one is:

Costs % difference from Soccer =

VAR __BASELINE_VALUE = [Costs for Soccer]

VAR __MEASURE_VALUE = [Total Costs]

RETURN

    IF(

        NOT ISBLANK(__MEASURE_VALUE),

        DIVIDE(__MEASURE_VALUE - __BASELINE_VALUE, __BASELINE_VALUE)

    )