Forum Discussion

cathyPB's avatar
cathyPB
Frequent Visitor
6 years ago
Solved

IF statement with Calculated Measure

 I would like to create a new measure with some value like this: IF  Before today: CALCULATE(  SUM('DataMart'[ACTUAL]),  FILTER(   ALLSELECTED('DIM_DATE'[DAY_DATE]),   ISONORAFTER('DIM_DATE'[DA...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    cathyPB - Does this measure work?:

     

    Your Measure 2 = 
var _Date_As_Of = MAX('Dim_Date'[Day_Date])
return CALCULATE(
    SUM('DataMart'[ACTUAL]),
    FILTER(
        ALL('Dim_Date'),
        AND(_Date_As_Of < TODAY(), 'Dim_Date'[Day_Date] <= _Date_As_Of)
    )
)

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

cathyPB - Does this measure work?:

 

Your Measure 2 = 
var _Date_As_Of = MAX('Dim_Date'[Day_Date])
return CALCULATE(
    SUM('DataMart'[ACTUAL]),
    FILTER(
        ALL('Dim_Date'),
        AND(_Date_As_Of < TODAY(), 'Dim_Date'[Day_Date] <= _Date_As_Of)
    )
)

 

 

cathyPB's avatar
cathyPB
Frequent Visitor
6 years ago

Not yet, it only return one value as the point in the chart

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    cathyPB  - Could you please mock up what you are looking for and provide a screenshot of what is currently happening?

    • cathyPB's avatar
      cathyPB
      Frequent Visitor
      6 years ago

      Anonymous   It works. The dot comes from the higher level, so drill down to lower level does work.Thanks.