Forum Discussion
Filter one column in a matrix
Hi Sk1_2 ,
Based on the description, try to create the new measure.
StaffCountOtherMonths = var _month = SELECTEDVALUE('Table'[Month name]) RETURN IF(_month <> "Jan-2024", SUM('Table'[staff count]))Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionSk1_2 So what is the source data for this as I assume this is the output you want?
Greg_Deckler Its SQL Server Database
- Greg_Deckler
Sk1_2 OK, I get that, but what does the table look like? Like this?
Column1, Column2, Column3
blue, 1/1/2024, 5
blue, 1/1/2025, 10
blue, 10/1/2024, 11
blue, 11/12/2024, 6
green, 1/1/2024, 5
green 1/23/2025, 7
These kinds of things really matter and it's not fun to guess or hand type a bunch of data.
Greg_Deckler Yes, thats what it looks like
Column1, Column2, Column3
blue, 1/1/2024, 5
blue, 1/1/2025, 10
blue, 10/1/2024, 11
blue, 11/12/2024, 6
green, 1/1/2024, 5
green 1/23/2025, 7
- Ashish_Mathur
Super User
Hi,
I do not understand. Create a Calendar Table with a relationship to the Fact Table. Create calculated columns of Year, Month name and Month number in the Calendar Table. To your slicer, drag Year and Month name from the Calnda table. select January 2025 there.
