Calculating for MAX also shows for other months in matrix

[newgirl]

Hello! I'm working on this report wherein the set-up of the data source is that it gets the files from a SharePoint folder. Each file represents each month and each file shows the value input per day.

File for JanuaryFile for February

I use 'SharePoint Folder' as the data source and then unpivot the seleced columns to have only 1 column for the input values.

In my report, below are the 2 tables involved (calendar and main table).

And in my report page, there's a filter for the YearMonth. The measure I made to get the Nominal Capacity per month is 

EquipNominalCap = CALCULATE(MAX(fSolidPackhouse[Value]),fSolidPackhouse[Source]="Equipment Nominal Capacity",'CR tbl_SellingDays'[YearMonth])

but when I place it in my matrix table, it shows correctnly the value per month but it also shows even the nominal capacity for February even though the filter is only for January 2022.

How could I fix the measure for the Nominal Capacity so that it would only show the value for the filtered YearMonth?

[DataInsights · Accepted solution]

@newgirl,

Try removing the third argument in CALCULATE:

EquipNominalCap =
CALCULATE (
    MAX ( fSolidPackhouse[Value] ),
    fSolidPackhouse[Source] = "Equipment Nominal Capacity"
)

[newgirl]

Thanks @DataInsights ! Forgot to try removing the last part. I thought it was important.