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

Hi Ashish,

 

I had in place your suggested relational structure. Applying your ABS Variance DAX changed the Varianbce to positive values but the total is still summing the same the Variance Total. 

The ABS Variance should be a much higher value. This is where I'm having issue.  Thanks.

 

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.