Forum Discussion
Matrix Table: Filter measure values without filtering row headers
Hi,
I hope someone could help me with how I could filter a matrix table (or even a regular table), but only the measures are affected not the row headers/items.
Ex. I have this datatable:
I want to create a visual table like this:
But, if I filter the age to something like between 2-7 the table should still display all age groups but the counts would reflect the filtered values:
Is this possible?
Thanks!
You can seperate the Age Group into a new table - you can use the dax
DimAge = Values(Table[Age Group])
Then, join this to your table. Use Age Group in the new table, then count from the original table. Make sure you click on Age Group and turn on 'Show items with no data'
This is creating a STAR schema, which is the reccomended way to model your data. You can read more here:
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Appreciate your Kudos
Connect with me!
1 Reply
You can seperate the Age Group into a new table - you can use the dax
DimAge = Values(Table[Age Group])
Then, join this to your table. Use Age Group in the new table, then count from the original table. Make sure you click on Age Group and turn on 'Show items with no data'
This is creating a STAR schema, which is the reccomended way to model your data. You can read more here:
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Appreciate your Kudos
Connect with me!