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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

You can merge Table1 into Table2 using the Query Editor.  Then write a calculated column formula to calculate the difference between the quantity columns.  Build your visual from the consolidaed Table2.  Use this measure

Variance = sum(Data{Difference[)

In the filter pane, apply a condition of Variance <> 0.

Hope this helps.