Forum Discussion
How to avoid aggregation?
you can use RELATED() / RELATEDTABLE() to reference column from another table. make sure tables are connected in the model view.
example: suppose you have a table named TableA and you want to sum up the 'X_Actual Resident Days' from another table named TableB, you can create a measure as:
Total_X_Actual_Resident_Days =
SUMX(
RELATEDTABLE(TableB),
TableB[X_Actual Resident Days]
)refer:
https://learn.microsoft.com/en-us/dax/related-function-dax
https://learn.microsoft.com/en-us/dax/relatedtable-function-dax
And for duplicating rows, do you have many-to-many relationships? Maybe that is causing the duplicates.
Community Champion
you can use RELATED() / RELATEDTABLE() to reference column from another table. make sure tables are connected in the model view.
example: suppose you have a table named TableA and you want to sum up the 'X_Actual Resident Days' from another table named TableB, you can create a measure as:
Total_X_Actual_Resident_Days =
SUMX(
RELATEDTABLE(TableB),
TableB[X_Actual Resident Days]
)
refer:
https://learn.microsoft.com/en-us/dax/related-function-dax
https://learn.microsoft.com/en-us/dax/relatedtable-function-dax
And for duplicating rows, do you have many-to-many relationships? Maybe that is causing the duplicates.