Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Should we assume that Table1 and Table2 are linked via the ID ?  Which of them is the  parent table?  or is it a 1:1 relationship (in which case the tables can be merged)?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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!

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    Please provide sample data that properly demonstrates the relationship.