I have an issue with my DAX calculate total based on filtered slicer

[sjpbi]

I have a dataset with column MeetingYrQtr based in meeting date, RegionCode and YrQtrName based on another table with dates. 

I want to change my dax PBWithMinsTQtrEXP to calculate total ProjsWithMins when MeetingYrQtr = YrQtrName that I selected from the slicer for example "2024 Q1" is the selected value in YrQtrName slicer it should display 12 as total 

The display is wrong when i used this formula 

PBWithMinsTQtrEXP = CALCULATE(SUM(PBMins[PrjsWithMins]),PBMins[MeetingYrQtr]= MAX(Dim_Date_ALL[YrQtrName]))

[Anonymous]

Hi @sjpbi ,

You can use var _select = selectedvalue(Dim_Date_ALL[YrQtrName])) to get the year you want, so your expression should change to PBMins[MeetingYrQtr]=_select

Best regards,
Community Support Team_ Scott Chang