creating dax that shows the total month result when i select a week in my filters.

[DarkNicobak]

Im having some trouble creating a measure that shows the total month result when i select a week in my filters.
My dashboard is filtered by year and week, and this measure is a sum of the total values in a collumn but must be displayed as a monthly result, not weekly
My goal would be to select week 1, and have the total result for January, select week 5 and have the total result for February, etc

[Rayshin · Accepted solution]

Hi @DarkNicobak  i recommend using this article: https://dax.guide/hasonevalue/ to check if the yyyy-mm column has one value,  then calculate the measure based on an unfiltered version but then filtered aginst that yyyy-mm