cancel
Showing results for
Did you mean:
jiglow3501 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.

1 ACCEPTED SOLUTION

Accepted Solutions 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

## 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