Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
LFORS
Frequent Visitor

Using SELECTVALUE to return previous related incident in a Matrix Table

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:

 

DateIncidentNumberResponsibleApp
1.1.23INC1App1
2.1.23INC2App2
3.1.23INC3App1
4.1.23INC4App1
5.1.23INC5App3

 

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:

 

IncidentNumberResponsibleApp
INC1App1
INC3App1
INC4App1

 

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

 

Thanks

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

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.

 

Jihwan_Kim_1-1705075033693.png

 

Jihwan_Kim_0-1705075011001.png

 

 

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

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

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.

 

Jihwan_Kim_1-1705075033693.png

 

Jihwan_Kim_0-1705075011001.png

 

 

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

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.