Forum Discussion

Prakash1050's avatar
Prakash1050
Helper III
3 years ago
Solved

Need Dax Measure

Hi All,            I have 3 tables "a", "b" and "c". The "a", "b" table have one common column and "b", "c" table have one common column. If in the filter pane i selected one value of common column ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Prakash1050,

    It seems like I shared the wrong formulas, you can take a look at the  following formulas that I fixed the wrong part and modify with the field name that you shared to get calculation result from Dax condition filters without really relationship mappings.

    formula =
VAR idList =
    CALCULATETABLE (
        VALUES ( TableB[Entity ID] ),
        FILTER ( ALLSELECTED ( TableB ), TableB[Key] IN VALUES ( TableA[Key] ) )
    )
RETURN
    CALCULATE (
        SUM ( TableC[Value] ),
        FILTER ( ALLSELECTED ( TableC ), TableC[Entity ID] IN idList )
    )

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Prakash1050,

It seems like I shared the wrong formulas, you can take a look at the  following formulas that I fixed the wrong part and modify with the field name that you shared to get calculation result from Dax condition filters without really relationship mappings.

formula =
VAR idList =
    CALCULATETABLE (
        VALUES ( TableB[Entity ID] ),
        FILTER ( ALLSELECTED ( TableB ), TableB[Key] IN VALUES ( TableA[Key] ) )
    )
RETURN
    CALCULATE (
        SUM ( TableC[Value] ),
        FILTER ( ALLSELECTED ( TableC ), TableC[Entity ID] IN idList )
    )

Regards,

Xiaoxin Sheng

Prakash1050's avatar
Prakash1050
Helper III
3 years ago

Hi Anonymous 
    Thank you so much this measure is working correctly.