Forum Discussion
Solved
Referring A Measure inside Another Measure
Hi, I have a problem with referring a measure in other measures. It seems that my second measure does not understand the reference, so could you generally explain a little bit about it? And here...
HI Ynew
Please try this MEASURE
TotalVolume = VAR mymonth = [LastMonth] RETURN COUNTAX ( FILTER ( 'Report1', 'Report1'[Month] = mymonth ), 'Report1'[Volume] )
Actually whats going on with your formula is that...... it is returning the Full Table.
Your MEASURE is calculated for each row of the Table and returns the Last Month for each filtered row.
Thats why you need to take the MEASURE out of the CALCULATE and put it in a VARIABLE before CALCULATION
TotalVolume =
VAR mymonth = [LastMonth]
RETURN
COUNTAX ( FILTER ( 'Report1', 'Report1'[Month] = mymonth ), 'Report1'[Volume] )
When you use
FILTER('Report1','Report1'[Month]=[LastMonth])
this returns the whole table instead of the Filtered Table with the LastMonth.
Why?
Because MEASURE is assessed for each ROW of the TABLE
Thats why you need to put the value of the MEASURE in a VARIABLE first