Using SELECTVALUE to return previous related incident in a Matrix Table

[LFORS]

Hi all,

I have been struggling with this one for quite some time and was hoping someone could help me.

Scenario

I have a table that contains major incident data including incident numbers and responsible application (that caused the issue). For simplicity sake the table looks like this:

Date	IncidentNumber	ResponsibleApp
1.1.23	INC1	App1
2.1.23	INC2	App2
3.1.23	INC3	App1
4.1.23	INC4	App1
5.1.23	INC5	App3

Outcome

I have a report page with a slicer were the user is able to select the IncidentNumber. I want to create a table in the report to display all the previous incidents that are related to the same ResponsibleApp for the incident they have chosen in the slicer.

Example: If a user selects INC1 in the slicer, the table would display the following:

IncidentNumber	ResponsibleApp
INC1	App1
INC3	App1
INC4	App1

Is this possible? Any help would be greatly appreciated on this.

Thanks

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if whether I understood your question correctly, but I tried to create a sample pbix file like below.

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

Responsible App Measure: =
VAR _selectedapp =
    DISTINCT ( Slicer[ResponsibleApp] )
RETURN
    MAXX (
        FILTER ( Data, Data[ResponsibleApp] IN _selectedapp ),
        Data[ResponsibleApp]
    )

[LFORS]

You are a life saver, this worked. Thanks alot, I really appreciate this!