cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jiglow3501 Frequent Visitor
Frequent Visitor

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 (syntax is not correct)

 

Difference between passers per year (measure 2) =

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

 

or May be betterway of writing this.

 

I appreciate your help.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: embedding dax measure within formula

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

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
2 REPLIES 2
Super User
Super User

Re: embedding dax measure within formula

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

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
jiglow3501 Frequent Visitor
Frequent Visitor

Re: embedding dax measure within formula

thank you for your help.