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
            )
KrisIsLearning's avatar
KrisIsLearning
Frequent Visitor
2 years ago

I'm getting into the correct direction:

 

        CONCATENATEX(
            FILTER(
                'Reports',
                'Reports'[Rubriek] = RELATED(KnownRubrics[Rubriek])
            )
            ,
            'Reports'[Rubriek],
            ", ",
            'Reports'[Rubriek],
            ASC
        )