Forum Discussion

KrisIsLearning's avatar
KrisIsLearning
Frequent Visitor
2 years ago
Solved

Filtering data in DAX with a related table

I know how to do it with M but want to get more into DAX syntax but I need a few hints from the community.   I've got 2 tables set up:   KnownRubrics RubriekCondition aard ok wgnr nok...
  • KrisIsLearning's avatar
    KrisIsLearning
    2 years ago

    I'm getting into the correct direction:

     

            CONCATENATEX(
                FILTER(
                    'Reports',
                    'Reports'[Rubriek] = RELATED(KnownRubrics[Rubriek])
                )
                ,
                'Reports'[Rubriek],
                ", ",
                'Reports'[Rubriek],
                ASC
            )
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
2 years ago

hi KrisIsLearning ,

 

could you provide the expected result as a table as well?

KrisIsLearning's avatar
KrisIsLearning
Frequent Visitor
2 years ago

I updated the original post.