Forum Discussion

1001's avatar
1001
Resolver II
3 years ago

Help creating a table from other tables.

Hi All, every DAX example I find on the web is not working. I have three tables: tbl_Date (col: Date) tbl_Delivered (col: Del qty) tbl_Forecast (col: Fcst qty)   Step 1 - bring these columns t...
Need Help
1001's avatar
1001
Resolver II
3 years ago

Sorry Ashish, this is company info, I would be prohibited from making it available. But below is what I'm encountering using a Matrix table. You can see the bottom Totals row, the Var and ABS Var are exactly the same number at 3,846 where the ABS Var total should be 14,530.

 




Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Try this measure

ABS var_new = SUMX(VALUES(Data[Product]),[ABS var])

Replace Data[Product] with the table and column name which you have dragged to the row labels of the matrix.

  • 1001's avatar
    1001
    Resolver II
    3 years ago

    Thanks Ashish,  but the issue with this formula is the Var number is a Measure, not a calculated column which SUMX needs to perform. And the Qty Del and Qty Fcst columns live in two separate tables. This is the mess I've run into. Thx.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      I cannot help witthout a file.  Simple.

      • 1001's avatar
        1001
        Resolver II
        3 years ago

        Hi Ashish, am creating a duplicate dummy PBI file. Will upload it tomorrow. Many thanks for your help.