Related Rows from Filtered Value

[stanleyaja]

Hello! I am trying to take a related rows from filtered value. Here's my data:

Alpha	Num (String)
A	1
B	1
C	1
D	2
E	2
F	3

I'm trying to make a drill-through page with the "details" inside it, first element is card, when the filtered Alpha is C, then show C on the card, and then the second element is table which shows any related Alpha that is the same Num as the filtered Alpha.
Example if the filtered Alpha is B:
Card: 

 B

Related Alpha:

Related Alpha

A

C

Thanks for any help 🙂

[ThxAlot · Accepted solution]

Easy enouogh, nothing but juggleing with filter context,

[Jihwan_Kim]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file whether it suits your requirement.

Card visual measure: = 
CONCATENATEX(Slicer, Slicer[Alpha], ", ")

Related Alpha measure: =
VAR _slicerselect =
    VALUES ( Slicer[Alpha] )
VAR _number =
    SUMMARIZE (
        FILTER ( ALL ( Data ), Data[Alpha] IN _slicerselect ),
        Data[Num (String)]
    )
RETURN
    CONCATENATEX (
        FILTER (
            Data,
            NOT ( Data[Alpha] IN _slicerselect )
                && Data[Num (String)] IN _number
        ),
        Data[Alpha],
        ", "
    )

[stanleyaja]

Thank you so much for the reply, but I'm not particularly sure about the filter system in Power BI, on my end, i use "Drill through" filters instead of "Filters" pane. Also I only have 1 data which consists Alpha and Num(String) with no slicer, iirc, Drill-through page is a filtered page depends on which value we selected on the previous page.
I've tried SELECTEDVALUE(Data[Alpha) to detects which Alpha is currently filtered, and FILTER() to return multirow Data, but I always got "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value." error.

[Jihwan_Kim]

HI,

Thank you for your message. 

One of the reasons why I create a disconnected slicer table is because,

-> selected value is shown on the card visual, but on the table visual.

I started from here to consider how to model the data.

Thank you.