Forum Discussion

Charcho's avatar
Charcho
Icon for Helper I rankHelper I
1 year ago
Solved

Operations SUMX table simple related

Hello, I have a beginner's question: How can I sum the values of attributes (A, B) and display the result in a new matrix for each? I created a DAX formula with SUMX, but it's not giving me the corre...
Need Help
Tips and Tricks
  • Charcho's avatar
    Charcho
    1 year ago

    Ashish_Mathur rajendraongole1 Deku solved my issue! Here's the link with the solution.

    https://www.dropbox.com/scl/fo/9qzy7t1nti2hgt0b2bsnr/AOXdgYX-n0wpPpMvDubjmVk?rlkey=z9g1t839bvk569oyxi550pqdr&st=rmcchlm0&dl=0

    I created two dimension tables (Fruit and Attribute) and established a relationship between them. The code I needed was. What do you think? Thank you

    Difference_Table2_Table1 =
    VAR SelectedAttribute = SELECTEDVALUE(Table1[Attribute], "None")
    VAR T_table2 =
        SUMX(
            FILTER(
                Table2,
                Table2[Attribute] = SelectedAttribute || SelectedAttribute = "None"
            ),
            Table2[Value]
        )
    VAR T_table1 =
        SUMX(
            FILTER(
                Table1,
                Table1[Attribute] = SelectedAttribute || SelectedAttribute = "None"
            ),
            Table1[Value]
        )
    RETURN
        T_table2 - T_table1
Deku's avatar
Deku
Icon for Super User rankSuper User
1 year ago

I would suggest first pivoting the data so that A and B are values in a single Category column. Then you put the Category column as a column header in your matrix and use a simple measure 

 

Sum( tbl[value])