Forum Discussion
jps_HHH
Helper II
Helper IIslicer for multiple tables
I have 3 different tables in the powerBI. However, there is also 3 columns that are common between the three tables. Table 1: column X ; P; N; Year; Site; Location Table 2: column A; Z; Year;...
If you create a dimensions for year, site and location and setup a 1 many relationship to your tables you can use the dimensions in the slicers.
If there are different locations between the tables, for example, you can use the following the make the dimension
Distinct(
Union(
Distinct( table1[location] ),
Distinct( table2[location] ),
Distinct( table3[location] )
)
)
