Forum Discussion
Dynamic Filtering
- 8 years ago
Apologies I didn't read the examples.
Is the Item code a load filter or a Slicer on all the data?
If a slicer then add a measure like this and Filter by the slicer for Item code and in the filter pane HasGV>0
HasGV = VAR GV = "GV100" RETURN CALCULATE ( COUNT ( Trans[Transaction Id] ), FILTER ( ALL ( Trans ), Trans[Transaction Id] = MAX ( Trans[Transaction Id] ) && Trans[Item Code] = GV ) ) - 8 years ago
Yeah the calc doesn't work for the order number but the whole table.
I tried a different tactic using a summary table. Here is another doc
https://1drv.ms/u/s!Aln7Q7AFJHneiW2FVW26L2xmf6OQ
Maybe this page will help use as it seems to solve a similar problem.
http://www.daxpatterns.com/basket-analysis/
How can I set-up dynamic filtering when I have below scenario ?
Say I have , Markets and I have Produt Units
I want to selectively show the data for my employees with below type of access
Type 1 - Belong to market ( easily done)
Type 2 - Belong to Product Unit ( easily done)
Type 4 - Global Access regardless of Market or Product Unit
Type 3 - Belong to a specific Market and specific Product Unit
For example - I have an employee who belongs to Market - America and part of Product Unit 1 and I want to display only the data for NAM --> Product Unit 1 can you help me on how the Type 3 can be implemented ?