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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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.


Go to My LinkedIn Page


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.


Go to My LinkedIn Page


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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors