locked
What's wrong with my dax formular RRS feed

  • 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

  • can you use this formula then?

    diff:=[Current]-[Previous]

    have you tried rewriting the big formula using intelli-sense?

    hth,
    gerhard


    - www.pmOne.com -

    Wednesday, September 18, 2013 8:54 PM
    Answerer