Forum Discussion

SBGoh's avatar
SBGoh
Icon for Helper I rankHelper I
2 years ago

Filter rows seems not working in dropdown list

Hi,  I have 3 Sales order tables below and they have the following relationship: SO_HEADER.SO_NUM = SO_ITEM.SO_NUM (1 to Many) SO_ITEM.SO_NUM = STATUS.SO_NUM and SO_ITEM.POS_NUM = STATUS.POS_NUM (...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

SBGoh , Create a new concatenated column in the Item and status tables and join those

New column in DAX

Key = [SO_NUM] & "-" & [POS_NUM]

SBGoh's avatar
SBGoh
Icon for Helper I rankHelper I
2 years ago

Hi amitchandak , yes I actually create a composite key that concatenate the 2 fields [SO_NUM] & "-" & [POS_NUM] in both tables. I create a 1:1 relationship. It is incorrect ? Table SO_ITEM has more records because only table STATUS is filtered.

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    SBGoh , Change that 1- Many from Status to item, it should work

    • SBGoh's avatar
      SBGoh
      Icon for Helper I rankHelper I
      2 years ago

      Then the direction should be single or both ?

    • SBGoh's avatar
      SBGoh
      Icon for Helper I rankHelper I
      2 years ago

      I tried single and both direction, seems filtering is not working. ☹️