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 No, you would have to write a measure to do that kind of thing. Hard to really say though as there is extremely little information provided.
Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Greg_Deckler Thank you. I figured so. Please see sample data below and expected output. I would like to filter the month of January to only show data for 2025. Currently the month of January is displaying 2024
| October 2024 | November 2024 | December 2024 | January 2025 | |
| Blue | 5 | 5 | 5 | 10 |
| Green | 6 | 6 | 6 | 15 |
| Yellow | 3 | 3 | 3 | 7 |
Row: Project
Column: Month
Values: staff count
Thank You in advance,
- Greg_Deckler
Sk1_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.