Forum Discussion
Multiple filters on multiple tables
Anonymous
1) Create dimension tables in Power Query or using DAX for both the name and date fields. You then create a one-to-many relationship with the corresponding fields in the fact tables:
2) create SUM measures for the values in each table
3) create the slicers using the fields from the dimension tables. Create the visuals using the fields from the dimension tables and add the measures
I've attached the sample PBIX file for you
Community ChampionAnonymous
1) Create dimension tables in Power Query or using DAX for both the name and date fields. You then create a one-to-many relationship with the corresponding fields in the fact tables:
2) create SUM measures for the values in each table
3) create the slicers using the fields from the dimension tables. Create the visuals using the fields from the dimension tables and add the measures
I've attached the sample PBIX file for you
Thank you, it worked like a charm even on my original 8 tables. (i know i said 3 but its easier to ask)
Also to mention it also works on averages and/or percentages
- PaulDBrown
Anonymous
Glad to hear!
it will work with any calculation. This is the recommended model structure for multiple fact tables containing common fields. The use of the dimension tables allows for the filter context, where equivalent rows (fields) are filtered by the common dimension to allow for calculations.
Let us know if you need any further help!Best,
Paul