CALCULATE used in True/False expression?

[Anonymous]

I have used the following to calculate the lower quartile upper value.

Percentile = CALCULATE(PERCENTILE.INC(Table1[Ordinary Pay (in the month of April)],0.25),Table1[Ordinary Pay (in the month of April)]<>0,Table1[Ordinary Pay (in the month of April)]<>Blank())

It returns a number.

The next calculates the amount of values less than 1000.

Measure = Calculate(Count(Table1[Ordinary Pay (in the month of April)]),Table1[Ordinary Pay (in the month of April)]<1000)

This also returns a number.

However, when I join them together by replacing the 1000 with the quartile calculation, I get an error.

Measure = Calculate(Count(Table1[Ordinary Pay (in the month of April)]),Table1[Ordinary Pay (in the month of April)]<(CALCULATE(PERCENTILE.INC(Table1[Ordinary Pay (in the month of April)],0.25),Table1[Ordinary Pay (in the month of April)]<>0,Table1[Ordinary Pay (in the month of April)]<>Blank())))

Returns an error.

Why?

[tamerj1]

Hi @Anonymous 
Please try

Measur =
VAR X =
    CALCULATE (
        PERCENTILE.INC ( Table1[Ordinary Pay (in the month of April)], 0.25 ),
        Table1[Ordinary Pay (in the month of April)] <> 0,
        Table1[Ordinary Pay (in the month of April)] <> BLANK ()
    )
RETURN
    CALCULATE (
        COUNT ( Table1[Ordinary Pay (in the month of April)] ),
        Table1[Ordinary Pay (in the month of April)] < X
    )