Forum Discussion
Store data from a selected value in a slicer and use those data to filter another table
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])
Solution SupplierHi 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)
- Aburar_123
You can also use values('Table'[Inv.Nr]) instead of AllSelected('Table'[Inv.Nr])
Sorry because I am new at Power BI,
I don't understand this statement (InvNr_from_another_table what should this be?
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.