Forum Discussion

Hong_HW's avatar
Hong_HW
Frequent Visitor
3 years ago
Solved

Need help on filter dax

Hi, I'll need some help on the dax formula.   I have 2 tables below Table 1 named Country with 2 columns Country rollup Hub CTY CTY TH ASEAN MY ASEAN CN NASIA HK NASIA ...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Hong_HW 

    Try like:
    Measure =
    IF(
       SELECTEDVALUE(Table1[Country]) = "CTY",
       SUMX(ALL(Table2),Table2[USD]),
       SUM(Table2[USD])
    )
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Hong_HW 

in table1, is TH actually PH?

What does CTY mean? (The others stand for countries or regions)

ASEAN and NASIA are not countries, so they could not in the same column as PH, right?

  • Hong_HW's avatar
    Hong_HW
    Frequent Visitor
    3 years ago

    oh, yes there is typo , TH is actually PH.

    CTY means for all countries sum up