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
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Share the download link of your PBI file.

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.