topic Re: Using SELECTVALUE to return previous related incident in a Matrix Table in DAX Commands and Tips

Using SELECTVALUE to return previous related incident in a Matrix Table

LFORS — Fri, 12 Jan 2024 11:27:28 GMT

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

Re: Using SELECTVALUE to return previous related incident in a Matrix Table

Jihwan_Kim — Fri, 12 Jan 2024 15:57:43 GMT

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] )

Re: Using SELECTVALUE to return previous related incident in a Matrix Table

LFORS — Sat, 13 Jan 2024 01:33:03 GMT

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