Calculate with combined filters

[xariet]

Hi All

I need to calculate the median price for the year 2022 Q2. I have the following measure which doesn't work 

Med Price for Q2 2022 = CALCULATE(MEDIAN('output for power BI'[Price]), year('output for power BI'[Date])=2022, QUARTER('output for power BI'[Date]= 2))

I have tried another calculation as well, but it didn't work either

Med Price for Q2 2022 = CALCULATE(MEDIAN('output for power BI'[Price]), year('output for power BI'[Date])=2022 &&  QUARTER('output for power BI'[Date]= 2))

I am getting the result in the report where the price is showing for Q1 and Q2 2022. How do I get the price only for Q2 2022?

thank you 

UPDATE:

I have changed my date, Instead of auto date which I was using before I now use Calendar Table. And the output I am getting is different, but still not correct. In my report I need to see number $440 not $435. What is wrong here?

[Anonymous · Accepted solution]

HI @xariet,

Perhaps you can try to add them into the filter function to calculate with current filter effects:

Med Price for Q2 2022 =
CALCULATE (
    MEDIAN ( 'output for power BI'[Price] ),
    FILTER (
        ALLSELECTED ( 'output for power BI' ),
        YEAR ( [Date] ) = 2022
            && QUARTER ( [Date] ) = 2
    )
)

If the above also don't help, please share some dummy data and more detailed information to help us clarify your scenario and test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[xariet]

thank you @Anonymous , your solution worked!

[xariet]

thank you @vicky_ , removing the bracket didn't help

[vicky_]

This might be a typo issue. Check that the last part of that formula is changed from:  

QUARTER('output for power BI'[Date]= 2))
to
QUARTER('output for power BI'[Date])= 2) 

(basically just change the brackets a bit)