Help with static Measures

[alora101]

Hi All,

I dont know how to explain my situation but i will try to make it simple.

I have a measure called gross amount which is the total of unit price

gross amout = sum(unit price)

The issue i have is , i want to make this gross amount static ( when i apply filters it wont affect it because i want to use it to do other calulation for example

Product        gross amount

A                 300

B                200

C               400

TOTAL  900

Now, if i apply filter on product A and B which is 500, i want to be able to get the

1. percetage of 500/900 ,

2. 900- 500  etc

just to make the grand total to ignore the filter but be able to use the filter total against the grand total.

any help will be much appreciated. 

[v-chuncz-msft]

@alora101,

You may simply add ALL Function.

Measure =
CALCULATE ( SUM ( Table1[unit price] ), ALL ( Table1[Product] ) )

[alora101]

HI Sam,

Thanks for your solution however, if i try to do the sum of sum of the filter total against the all product i dont get to see the result rather the filter result.

for example.. when i appied the ALL to the calculation i get the desire result which is  500 but when filter the product and the sum of that is 300 , i want to be able to divide or subtract 300 from 500.

Hope this explanation helps and thanks very much for this info.

[v-chuncz-msft · Accepted solution]

@alora101,

Just change it as follows.

Measure =
DIVIDE (
    SUM ( Table1[unit price] ),
    CALCULATE ( SUM ( Table1[unit price] ), ALL ( Table1[Product] ) )
)