Only filters on column values but show total on all

[Anonymous]

Hi all,

I am required to show total no. of joiners and leavers by clubs but all show no. of joiners by Competitors, with Competitors being one of the Catogory from many category values.

So, on top I have to display only Competitors name (and not all members have Competitors filled in, it can be anything in the Category column) but display total joiners and leavers for that month.

How can I achieve this please.

[v-xiaotang]

Hi @Anonymous 

Thanks for reaching out to us.

Can you share some sample data? thanks

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You can add a filter

calculate([Joiner measure], filter(Table, Table[Type] <> "Competitor"))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.