Filter one visualisation

[Albertvw]

I want to add a single Card which filters differently to rest of report, i.e. only show ave of score of latest months' data.

I created new measure which works, i.e.: M1 = Calculate(Max(CSI[Month]))

Then to filter for latest month CSI score: M1CSI = Calculate(Average(CSI[CSI], Filter(CSI, CSI[Month] = CSI[M1]))

This however still calculates base on full set of filters on the page?

Thank you

[maracles]

Do you want the single card visualisation to show ONLY the CS! Score for the latest month, and all other visualisations to show the CSI for all months? 

Are you doing this entirely through your measure or do you have other filters applied at either a Visual or Page level? 

[Albertvw]

Yes, the single card only should show latest month.

Rest of Page level has different filters applied to that. However, my single card filters according to rest of the page filters, meaning the filters applied to the other visuals on the page should not affect the card calculation.