Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreThe FabCon + SQLCon recap series starts April 14th at 8am Pacific. If you’re tracking where AI is going inside Fabric, this first session is a can't miss. Register now
I have two primary tables, one which describes sample information, and a related table with results based on the field ID.
tbl_Info
| ID | Detail 1 | Detail ... x |
| 1 | a | x |
| 2 | b | y |
| 3 | c | z |
| 4 | a | y |
| 5 | d | i |
tbl_Results
| ID | Feature | Result |
| 1 | a | 100 |
| 1 | b | 200 |
| 1 | c | 250 |
| 2 | c | 500 |
| 2 | e | 40 |
| 3 | h | 600 |
| 3 | a | 850 |
| 4 | g | 100 |
| 5 | g | 200 |
Info ID is related 1:* on the Results ID
Here's where the trouble comes in:
I have a table of "Related Samples" which I want to compare the results of the two samples. Esentially pointing ID to ID.
RelatedSamples
| ID | Related ID |
| 1 | 3 |
| 1 | 2 |
| 4 | 5 |
I have a report tab which uses measures to compare the results from each test based on two slicers slicers:
RelatedSamples[ID]
RelatedSamples[RelatedID]
I'd like to create a button to drill through to all the details of either the slicer selections on another report tab.
I cannot create a relationship between RelatedSamples and tbl_Info since both [ID] & [RelatedID] fields are the same relationship. Therefore the slicers on the comparison tab are unrelated to tbl_Info, and a button cannot be used either. Suggestions?
@Ghoom , You drill using tbale 1 and table 2
and then use a measure to capture values
example
countrows(filter(RelatedSamples , RelatedSamples [ID] in Values(tbl_Info[Values]))
or vice versa. Make sure the drill page, you add the columns on which you want to drill
I appreciate the response! I was hoping I wouldn't have to go this route as I currently have created the "details" page controlled by a tbl_Info[ID] filter.
It seems the only way to do this is re-creating each visual on the "details" page with a new measure?
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 52 | |
| 38 | |
| 37 | |
| 19 | |
| 18 |
| User | Count |
|---|---|
| 67 | |
| 67 | |
| 34 | |
| 32 | |
| 29 |