none
What's wrong with my dax formular

    Question

  • Hi all,

    I am trying to calculate a measure based on another measure. The Measure I already created is MsrValue. Then I tried to create another measure as following:

    diff:=calculate([MsrValue], dimPeriod[PeriodIndicator]=1)-CALCULATE([MsrValue],dimPeriod[PeriodIndicator]=2)

    There is no compilation error message but always return empty. 

    I created other two seperate measures:

    Current:=calculate([MsrValue], dimPeriod[PeriodIndicator]=1)

    Previous:=CALCULATE([MsrValue],dimPeriod[PeriodIndicator]=2)

    There is no any problem with these two measures.

    Any idea why the bolded measure failed? Your help will be much appreciated.

    Thanks,

    Allen

    Tuesday, September 17, 2013 6:31 PM

Answers