Forum Discussion
Row filter at person level
Hi Arial12,
You can refer to below steps to filter visual by previous filter result.
Steps:
1. Use color column to create new table as selector.
Color = VALUES('sample'[Product color])
2. Write measure to compare current item with select item, return flag based on check result.
Flag =
VAR current_id =
LASTNONBLANK ( 'sample'[vendor id], [vendor id] )
VAR filtered =
CALCULATETABLE (
VALUES ( 'sample'[vendor id] ),
'sample'[Product color] IN ALLSELECTED ( Color[Product color] )
)
RETURN
IF ( NOT ( current_id IN filtered ), "Y", "N" )
3. Create table visual(original table) and slicer(color selector table).
4. Drag measure to table visual visual level filter, switch mode to 'is', filter flag 'Y'.
Result:
Regards,
Xiaoxin Sheng
Thank you so much Xiaoxin Sheng but I am connectin in DirectQuery Mode.
so, Lastnonblank doesn't work there. any other idea?
Thanks,
- Anonymous8 years agoNot applicable
Hi Arial12,
Current I also not have any effective methods to achieve this on 'direct query' mode, perhaps you can submit an idea for this requirement.
Regards,
Xiaoxin Sheng
- Arial128 years agoFrequent Visitor
I was able to accomplish this without lookup function. i will post my solution shortly.