Forum Discussion

BDolphin's avatar
BDolphin
Helper I
6 years ago
Solved

Filtered table to filter another table

I am looking to filter a table based on the filtered results from a drill through. On the main page I have a table of names, I would like to drillthrough and go to their "Associates" on another page....
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hello, @BDolphin

    You can modify the "Count" measure as follows.

    Count = 
SUMX(
    'Name Table',
    CALCULATE(
        COUNTROWS(
            FILTER(
                ALL('Table'),
                'Table'[Name] = MAX('Name Table'[Names])
                &&  'Table'[OccurrenceNo] in DISTINCT('Table'[OccurrenceNo])
            )
        )
    )
)

    result:

    a1.png

    Best regards

    Allan

    If this post helps,then please consider Accepting it as the solution to help the other members find it more quickly.

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hello, @BDolphin

You can modify the "Count" measure as follows.

Count = 
SUMX(
    'Name Table',
    CALCULATE(
        COUNTROWS(
            FILTER(
                ALL('Table'),
                'Table'[Name] = MAX('Name Table'[Names])
                &&  'Table'[OccurrenceNo] in DISTINCT('Table'[OccurrenceNo])
            )
        )
    )
)

result:

a1.png

Best regards

Allan

If this post helps,then please consider Accepting it as the solution to help the other members find it more quickly.

BDolphin's avatar
BDolphin
Helper I
6 years ago

Thank  you so much, that worked perfectly