Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
Solved! Go to 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]
)
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.
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]
)
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.
You are a life saver, this worked. Thanks alot, I really appreciate this!
User | Count |
---|---|
18 | |
12 | |
10 | |
10 | |
6 |
User | Count |
---|---|
23 | |
22 | |
20 | |
15 | |
10 |