Split result of measure on other categories

[Anonymous]

Hi 

I have a challenge for you all that I've been trying to solve for a while. 

I have a few categories. I have GGR, and a % distribution of total GGR. Further, I have a direct cost for each category and I have others costs which in this case is  1 380.57. I want to distribute this cost based on the %-distribution of GGR, as shown in the yellow column. When I make a measure to filter out other costs and multiply it with the %-distribution it returns zero for the categories other than other costs, due to the filtering of categories.

Is it possible to use the measure value as just a value in the computation of the "other costs"- distribution? I have not managed to solve this and ended up hardcoding the number in the formula, but that does not make it very dynamic. I would like to not use calculated columns if possible since the dataset is large enough as it is. 

Thank you in advance! Christer

[DataInsights · Accepted solution]

@Anonymous,

Try this measure:

Other Costs Distribution = 
VAR vOtherCosts =
    CALCULATE ( SUM ( Table1[Direct Cost] ), Table1[Category] = "Other Costs" )
VAR vResult = vOtherCosts * [GGR %]
RETURN
    vResult