Forum Discussion
Store data from a selected value in a slicer and use those data to filter another table
Hello everyone,
Thank you again for your time here and it is very helpfull what you are doing here. I am working currently in one project with big data and want to improve some of our visualizations. I will get very easily and not complicated. What I want to do is to use the data that is filtered from a slicer and use those to filter another table. Maybe using DAX measures to store the data from this filtered table and then with those data I will filter another one. I don't want to do this manually because what I am working for is quite a lot data and it will take a lot of time to take manually and filter the other table. I am using this example just for explanation purpose only.
Thanks a lot!
I just give the name to understand. it means the column name on top of it you are going to check the value returned from AllSelected('Table'[Inv.Nr])
8 Replies
- Aburar_123
Solution Supplier
Hi xhulioberberi ,
For example if you want to use that filtered list of 'Table'[Inv.Nr] values in any measure then you can get it by writing like Allselected('Table')
Can you write me an example please? And the measure I should put it to the other table?
- Aburar_123
Hi xhulioberberi ,
May i know what do you mean by the word "the measure I should put it to the other table" exactly.
My understanding from this statement is that you need to hold that filtered list of Inv.Nr as a measure table to use it in a measure called Test then in that case you can write like below,
Test =
var Filtered_list_of_InvNr = AllSelected('Table'[Inv.Nr])
return if(InvNr_from_another_table IN Filtered_list_of_InvNr, 1, 0)
Hi xhulioberberi ,
Have you resolve the issue now? If so, please provide the answer and mark the reply to the solution to close the case. If not, please provide your pbix file without privacy information and desired output with more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
