Matrix - Filter on column subtotals

[abhishek_2593]

Hi,
I have created a matrix chart from a database for analysis and would like to filter out certain data which does not meet the criteria .

My requirement is that i should retain only the data which has a column subtotal count of 4 or more.

Is there a way we could filter out the data from the below database using count or other functions?

[speedramps · Accepted solution]

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 !