Concatenatex with Slicers

[ronnie_roberts]

I have a report with 2 slicers on it, one for Program Increment Name and one for Epic Name.  What I'm trying to do is create a concatenation of all of the Program Impliments an Epic is part of that would ignore the Program Increment slicer so people could see if an Epic is about to end.  Can anyone tell me what I'm doing wrong?  When I run this currently I'm still only getting the selected PI rather than the 2 PIs I would expect.

PI List = 
CALCULATE(
    CONCATENATEX(
        DISTINCT(
            SELECTCOLUMNS(
                StoriesToThemes,
                "Epic", StoriesToThemes[Epic Name],
                "PI", StoriesToThemes[PI Name]
            )
        ),
        [PI],
        ", "
    ), REMOVEFILTERS(StoriesToThemes[PI Name])
)

Data:

Epic Name	Feature Name	Story Name	PI Name
Epic 1	Feature 1	Story 1	PI 1
Epic 1	Feature 1	Story 2	PI 1
Epic 1	Feature 2	Story 3	PI 2
Epic 1	Feature 2	Story 4	PI 2

Where as Epic 1 appears in PI 1 & 2 I would expect PI List to be "PI 1, PI 2" but instead it always seems to respect the PI slicer and only shows the selected PI.

Thanks in advance!

[NaveenGandhi · Accepted solution]

Hello @ronnie_roberts 

Just try the below version of the DAX.
PI List =
CALCULATE (
CONCATENATEX (
DISTINCT (
SELECTCOLUMNS (
StoriesToThemes,
"Epic", StoriesToThemes[Epic Name],
"PI", StoriesToThemes[PI Name]
)
),
[PI],
", "
),
REMOVEFILTERS ( StoriesToThemes[PI Name] ),
ALLEXCEPT ( StoriesToThemes, StoriesToThemes[Epic Name] )
)

Let me know if this helps!

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

[ronnie_roberts]

That did it!  I spent 2 days trying to figure that out!