One dimension table filters another dimension table

[dw700d]

I am attempting to have one Dimension table filter another.I attempted to get the State table to filter the all locations table, Specifically I would like the location code column to be filtered by state. I did this by creating a measure on the Activity table.

PO Value = SUM(Activity[Total PO Value]

I then placed that measure in the visual filter of a Table With a list of location codes.

Using this method I am succsefuly able to filter location code by state but when I try to filter “count of location code”  by state I am unable to do so. The number remains static regardless of what state I select

How can I filter the count of location code by state ?

[v-kkf-msft · Accepted solution]

Hi @dw700d ,

If you want to get the State table to filter the all locations table, you need to change the relationship between tables to Both. 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[amitchandak]

@dw700d , Measure from the fact activity should help.

Refer to this video- https://www.youtube.com/watch?v=cyOquvfhzNM

few users recently reported that, this did not work for them