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,
I have a datasource table, which has
Type Key Parent
Solution S123 T123
Solution S456 T123
Feature F123 S123
Feature F456 S123
Feature F999 S123
1) I have a slicer which has all the Keys where the Type=Solution
2) I have Table1 on the report that shows all the Solutions and is driven by the slicer (All=show all or select a specific Solution Key, i.e. S123)
3) The next table on the report, is where I need to show the following if S123 Solution is selected:
F123
F456
F999
Solved! Go to Solution.
Hi @EaglesTony
Check the attached for the solution. I have created a disconnected table for slicer and used 2 measures as visual level filter.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
Hi,
Here's my approach
Measure = calculate(countrows(Data),userelationship(Data[Parent],Table1[Key]))
Hope this helps.
I was thinking maybe some way using the "selected value" of the table selection ? or since they data is in the same table trying to setup a parent/child relationship, not sure if self-relationships are allowed?
Hi @EaglesTony
Check the attached for the solution. I have created a disconnected table for slicer and used 2 measures as visual level filter.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
Can you post the code here ?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
124 | |
79 | |
49 | |
38 | |
38 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |