Forum Discussion

Ynew's avatar
Ynew
Helper I
8 years ago
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...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI Ynew

     

    Please try this MEASURE

     

    TotalVolume =
VAR mymonth = [LastMonth]
RETURN
    COUNTAX ( FILTER ( 'Report1', 'Report1'[Month] = mymonth ), 'Report1'[Volume] )

     

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Ynew

 

Did you revise the Total Volume formula as per below?

 

 

TotalVolume =
VAR mymonth = [LastMonth]
RETURN
    COUNTAX ( FILTER ( 'Report1', 'Report1'[Month] = mymonth ), 'Report1'[Volume] )

 

Ynew's avatar
Ynew
Helper I
8 years ago

Zubair_Muhammad

 

Yes I did and tested it for my real data, so yes it is working. Thank you very much.