Forum Discussion
Slow when using filter pane
Hi, I have 2 main tables in my model. I need to show which ID's QTY is not match and the variance so that I have a measure: variance = sum(table1[QTY]) - sum(table2[QTY]) I want to show th...
lbendlin , yes, the key column is "ID" to map.
It is a One to Manay relationship between Table1 : Table2
Cannot do merge in this case because Table2's QTY can be filtered by other columns before calculating the variance so it is needed to be on the DAX.
Thanks!
Please provide sample data that properly demonstrates the relationship.