Forum Discussion

Frequent Visitor

4 years ago

Solved

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...

Aburar_123
4 years ago
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])

Aburar_123

Solution Supplier

4 years ago

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

Solution Supplier

4 years ago

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

xhulioberberi
Frequent Visitor
4 years ago
Sorry because I am new at Power BI,
I don't understand this statement (InvNr_from_another_table what should this be?
- Aburar_123
  Solution Supplier
  4 years ago
  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])