Static and dynamic calculations with same slicing

[Jensk]

I have this test data:

Entity	Company	Customer	Amount	Price
Entity 1	Company1	Customer1	17	66,95
Entity 1	Company1	Customer2	49	249
Entity 1	Company2	Customer3	8	227,35
Entity 1	Company2	Customer4	46	385,74
Entity 2	Company3	Customer5	29	592,05
Entity 2	Company3	Customer6	30	20,29
Entity 2	Company4	Customer7	46	891,46
Entity 2	Company4	Customer8	24	822,71
Entity 1	Company1	Customer1	18	190,09
Entity 1	Company1	Customer2	20	750,22
Entity 1	Company2	Customer3	8	283,53
Entity 1	Company2	Customer4	31	146,72
Entity 2	Company3	Customer5	44	871,95
Entity 2	Company3	Customer6	30	123,9
Entity 2	Company4	Customer7	43	936,6
Entity 2	Company4	Customer8	14	839,91
Entity 1	Company1	Customer1	27	802,02
Entity 1	Company1	Customer2	21	393,18
Entity 1	Company2	Customer3	34	650,46
Entity 1	Company2	Customer4	45	930,55
Entity 2	Company3	Customer5	5	959,85
Entity 2	Company3	Customer6	27	709,72
Entity 2	Company4	Customer7	42	356,27
Entity 2	Company4	Customer8	37	945,8
Entity 1	Company1	Customer1	35	919,21
Entity 1	Company1	Customer2	13	885,57
Entity 1	Company2	Customer3	28	682,22
Entity 1	Company2	Customer4	4	398,22
Entity 2	Company3	Customer5	10	757,28
Entity 2	Company3	Customer6	33	855,14
Entity 2	Company4	Customer7	21	316,09
Entity 2	Company4	Customer8	9	909,33
Entity 1	Company1	Customer1	9	195,81
Entity 1	Company1	Customer2	30	205,67
Entity 1	Company2	Customer3	10	562,07
Entity 1	Company2	Customer4	10	229,25
Entity 2	Company3	Customer5	14	38,52
Entity 2	Company3	Customer6	32	179,08
Entity 2	Company4	Customer7	4	625,6
Entity 2	Company4	Customer8	48	386,29
Entity 1	Company1	Customer1	2	714,3
Entity 1	Company1	Customer2	21	873,84
Entity 1	Company2	Customer3	47	381,9
Entity 1	Company2	Customer4	34	293,29
Entity 2	Company3	Customer5	43	245,75
Entity 2	Company3	Customer6	13	882,22
Entity 2	Company4	Customer7	10	126,71
Entity 2	Company4	Customer8	8	855,36
Entity 1	Company1	Customer1	38	587,44
Entity 1	Company1	Customer2	41	401,24
Entity 1	Company2	Customer3	3	368,76
Entity 1	Company2	Customer4	50	263,24
Entity 2	Company3	Customer5	44	493,07
Entity 2	Company3	Customer6	15	56,46
Entity 2	Company4	Customer7	29	664,4
Entity 2	Company4	Customer8	2	839,34
Entity 1	Company1	Customer1	27	965
Entity 1	Company1	Customer2	2	817,39
Entity 1	Company2	Customer3	34	803,59
Entity 1	Company2	Customer4	38	98,96
Entity 2	Company3	Customer5	5	312,12
Entity 2	Company3	Customer6	8	123,65
Entity 2	Company4	Customer7	30	360,22
Entity 2	Company4	Customer8	42	773,32

I need to slice by a hierarchy of entities that consists of companies that each have their customers. I can look at numbers for the Entity or for a Company within the Entity:

My Measures:

Revenue = SUMX( Sales, Sales[Amount] * Sales[Price] )

% of Total Revenue = DIVIDE( [Revenue], CALCULATE([Revenue],ALLSELECTED()))

Fixed Cost = 10000*[% of Total Revenue]

 I need the '% of Total Revenue' to be dynamic with my slicer and 'Fixed Cost' to be static (always 

10000*[% of Total Revenue] by Company.

So my fixed cost for Customer1 should always be 5510,54 regardless of slicing:

When I select the Entity my Fixed Cost should remain unchanged (Static at the Company level)

How do I change my Fixed Cost measure to be static while keeping my '% of Total Revenue' dynamic?

[AlexisOlson · Accepted solution]

ALLSELECTED removes the company filter context, so try putting that back in explicitly like this:

Fixed Cost =
10000
    * DIVIDE (
        [Revenue],
        CALCULATE ( [Revenue], ALLSELECTED (), VALUES ( Sales[Company] ) )
    )

[Jensk]

Great, just what I needed. Thanks!