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
Charcho's avatar
Charcho
Icon for Helper I rankHelper I
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