Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to see all orders where one or more lines have a certain item number
(so I want to see everything the customors who bought redshirts have bought)
now i could filter for that item number but then i cannot see all the other items on that order.
Filter : item no =123
Order | item | show line ? |
1 | 123 | yes |
1 | 456 | yes |
1 | 466 | yes |
2 | 789 | No |
2 | 456 | No |
2 | 466 | No |
3 | 123 | yes |
3 | 123 | yes |
3 | 123 | yes |
So bassicly if item numer 123 has EVER been used on this order (within the other filter, date, department and so on I have on) I want to See ALL lines that match other filters.
Im lost - I could hardcode this on the table, but "123" needs to be a selectable value, next week we want to look at 398... and so on...
Solved! Go to Solution.
Hi, @Rygaard ;
You could create a table as a slicer .then create a flag measure apply it into filter.
1. create a table.
slicer = VALUES('Table'[item])
2.create a flag measure.
flag =
var _sel=SUMMARIZE(FILTER(ALL('Table'),[item] in ALLSELECTED('slicer'[item])),[Order])
return IF(MAX('Table'[Order]) in _sel,1,0)
3.apply it into filter.
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Rygaard ;
You could create a table as a slicer .then create a flag measure apply it into filter.
1. create a table.
slicer = VALUES('Table'[item])
2.create a flag measure.
flag =
var _sel=SUMMARIZE(FILTER(ALL('Table'),[item] in ALLSELECTED('slicer'[item])),[Order])
return IF(MAX('Table'[Order]) in _sel,1,0)
3.apply it into filter.
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Rygaard
I think you might interested in understanding single or multiple values from a Slicer selection can be used to impact measure. Please considering watching the following Curbal video to see if this helps. DAX Fridays! #118: Get selected or multiple values from slicers using DAX - YouTube