Store data from a selected value in a slicer and use those data to filter another table

[xhulioberberi]

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!

[Anonymous]

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.

[Aburar_123]

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')

[xhulioberberi]

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)

[xhulioberberi]

So from the data that has been filtered Inv.Nr so 1114,1115,1116 and 1117. I want to freeze these data in one measure or something else and then this data I want to use to filter another table.

[Aburar_123]

You can also use values('Table'[Inv.Nr]) instead of AllSelected('Table'[Inv.Nr]) 

[xhulioberberi]

Sorry because I am new at Power BI,

I don't understand this statement (InvNr_from_another_table what should this be?

[Aburar_123 · Accepted solution]

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])