Forum Discussion
Matrix - Filter on column subtotals
- 4 years ago
You have not explain what U10, U11, U12, U13 are. So we call them "Users".
Create a measure to get the totals for all users for the visual context (eg Club Name)
Total for all Users =
CALCULATE(SUM(yourtabelname[yourvalue]),
ALL( yourtabelname[Users]
)Then add Total for all Users >= 4 to your filter
Thanks for reaching out for help.
I have helped you, now please help me by giving kudos.
Remeber we are unpaid volunteers.
Click the thumbs up and accept as solution button.
One question per ticket please. If you need to extend your request then please raise a new ticket.
You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !
You have not explain what U10, U11, U12, U13 are. So we call them "Users".
Create a measure to get the totals for all users for the visual context (eg Club Name)
Total for all Users =
CALCULATE(
SUM(yourtabelname[yourvalue]),
ALL( yourtabelname[Users]
)
Then add Total for all Users >= 4 to your filter
Thanks for reaching out for help.
I have helped you, now please help me by giving kudos.
Remeber we are unpaid volunteers.
Click the thumbs up and accept as solution button.
One question per ticket please. If you need to extend your request then please raise a new ticket.
You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !