Trying to add dax to calculate all filters besied one.
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
