Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Relational tables

Dashboard below is drawing from sources from DM faddere 2018 hentet fra fadderskap, DM faddere 2018 hentet fra kontakt and DM Vervegiro reports. I need to include payment from the table below (DM fad...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous

Based on my understanding, you need to show columns/values from different fact tables together into a single visual or report.

In this scenario, it is better to create proper data models and aggregation function to use columns from other tables.

 

Here are some suggestions regrading creating correct data models and relationships

>>Multiple Data Tables in Power Pivot

     https://stackoverflow.com/questions/48624095/how-to-display-data-from-different-data-source-tables-in-a-single-table-in-power

Please check your relationship setting, for some tables, it is need to select "cross filter direction:both".

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships#cardinality

 

DAX will calculate the measures/columns against the common dimensions and then let you use the values for the different fact tables in the same analysis   

>>https://community.powerbi.com/t5/Desktop/Create-a-Calculated-Column-from-Different-Tables/td-p/60453

    Besides, sum, max or any other DAX functions you could consider.