Forum Discussion

jiglow3501's avatar
jiglow3501
Frequent Visitor
7 years ago
Solved

embedding dax measure within formula

I want to add measure1 into  measure2 formula:   Measure 1  Total Passers = CALCULATE(DISTINCTCOUNT(EXAMINEES[ID]),FILTER(EXAMINEES,EXAMINEES[PASS_DATE] <> BLANK()))   measure 2 -- DOES NOT WORK...
Need Help
  • TomMartens's avatar
    TomMartens
    7 years ago

    Hey,

    I guess this will already will do the trick:

    [Total Passers]
      - CALCULATE (
            [Total Passers] ,
                     FILTER ( ALLSELECTED ( EXAMINEES ),EXAMINEES[PASS YEAR] = MAX ( EXAMINEES[PASS YEAR] ) - 1 )
)

    SUM() and all the other aggregation functions expect a column reference, but not a measure.

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
7 years ago

Hey,

I guess this will already will do the trick:

[Total Passers]
      - CALCULATE (
            [Total Passers] ,
                     FILTER ( ALLSELECTED ( EXAMINEES ),EXAMINEES[PASS YEAR] = MAX ( EXAMINEES[PASS YEAR] ) - 1 )
)

SUM() and all the other aggregation functions expect a column reference, but not a measure.

 

Regards,

Tom

jiglow3501's avatar
jiglow3501
Frequent Visitor
7 years ago

thank you for your help.