Relatedtable - respect report filters

[arichards]

I have table A which has a one to many relationship with table B. I'm trying to do a calculated column (or maybe there's a better way) that counts all the related rows in table B with a certain filter AND respects the global report filters (I have a time slicer that filters on table B, among others). How do I do this? I can't figure out how to make relatedtable/calculate take the report filters into account.

Thanks!

[Mariusz · Accepted solution]

Hi @arichards 

The columns are executed on data model load, therefore report filters can not be applied.

You can create a Measure that will respect the report filters/filter context.

Please, can you create a data sample and present the required outcome.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.