Forum Discussion
Post PatronOne dimension table filters another dimension table
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 ?
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,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
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
v-kkf-msftCommunity Support
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,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
