Forum Discussion
Store measure as constant
Hi! I want to do two things. 1. Calculate a fraction (percentInvoiced) based on two columns (Budget and Costs). This fraction is filtered by a date filter. 2. Use this fraction to calculate the ...
Is the date slicer at the top coming from a different table to the year & month in the matrix visual? If so, you should be able to calculate the overall fraction by using REMOVEFILTERS on all of the tables which are referenced in the matrix, and any table which they are linked to. So you could create a measure like
can invoice = var overallFraction = CALCULATE( [prosentFakturert], REMOVEFILTERS('Sales'), REMOVEFILTERS('Date') ) return SUMX('Sales', 'Sales'[budget] * overallFraction)
johnt75
Super User
Super UserIs the date slicer at the top coming from a different table to the year & month in the matrix visual? If so, you should be able to calculate the overall fraction by using REMOVEFILTERS on all of the tables which are referenced in the matrix, and any table which they are linked to. So you could create a measure like
can invoice =
var overallFraction = CALCULATE( [prosentFakturert],
REMOVEFILTERS('Sales'),
REMOVEFILTERS('Date')
)
return SUMX('Sales', 'Sales'[budget] * overallFraction)