Trying to add dax to calculate all filters besied one.

[jaryszek]

Hi Guys,

I have used this dax on my fct_table:

% of Instance Total Cost Test = 
        DIVIDE(
            Sum(Fct_EA_AmortizedCosts[CostInBillingCurrency]),
        CALCULATE(
            SUM(Fct_EA_AmortizedCosts[CostInBillingCurrency]),
            Fct_EA_AmortizedCosts[PricingModel] = "OnDemand"
        ) 
        )

Page Filter is also "OnDemand". 

But it is always returning 100%...

Why? 

Generally i want to divide row filter context in table by sum of all this rows: 

but it is somehow giving 1,00 (100 %)...

Can anybody help ?

Goal: 
Keep filter context in table and always take current row sum of costs and divide by total row created from filter context...
why this is not working what i did? 

Best,
Jacek 

[MasonMA]

Hi Jacek,

For the denominator, you are calculating total cost of all rows visible under the page filters, but ignoring the row-level split. You'd need to clear the row-level filter while keeping the page filters with ALL() or REMOVEFILTERS() at the right level: 

CALCULATE(
SUM ( Fct_EA_AmortizedCosts[CostInBillingCurrency] ),
REMOVEFILTERS(Fct_EA_AmortizedCosts[PricingModel])

)