Forum Discussion
Data Modeling (Relationship issue)
Hello Brent_LaCorte
It is because Joe and Jim have transaction data from Shop # 3 and Shop # 4 .
If you remove incorrect data from data table, things would look more relevant.
Hope this helps.
Regards
Kumail Raza
The data itself isn't incorrect as sometimes Jim and Joe may have a transaction at those shops but they aren't on Craig's team so the numbers shouldn't be applied to Craig. The data is still relevant at a higher level, Manager for example, but looking specifically at the Supervisor team if the associate isn't on that supervisors team it needs to be filtered out and I am trying to do that without having a million slicers.
As you requested initially, it is getting filtered by shop dimension through Supervisor filter.
Thats getting a bit complicated..
You can create a measure that filters data by Hierarchy dimension with supervisor category where you select Shop dimension with supervisor category in filter.
measure = CALCULATE(SUM(data[Amount]), RELATEDTABLE(shop_list))If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and I would love to see your like.
Regards
Kumail Raza