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] )
To avoid returnning a table I put the first measure as below:
LastMonth= CALCULATE(LOOKUPVALUE ('Table1'[Month], 'Table 1'[Month#], MAX('Table1'[Month#]), ALL( Table1))
and put a filter in the report level filter, to exclude "Dec" from the month column in Table1.
But again this is not working! because:
1. LastMonth mesure avoids the filter on the month column and returns "Dec" instead of "Nov".
2. Even when LastMonth meausre returns "Dec", the second measure TotalVolume does not work properly with referring to the first measure.
Did you revise the Total Volume formula as per below?
TotalVolume =
VAR mymonth = [LastMonth]
RETURN
COUNTAX ( FILTER ( 'Report1', 'Report1'[Month] = mymonth ), 'Report1'[Volume] )
Yes I did and tested it for my real data, so yes it is working. Thank you very much.