Forum Discussion
Solved
Overlapping data slicer
Hi guys, I have an interesting one that I am unsure how to tackle. I have several pieces of wire connecting to each other over a length, the wires overlap each other as they transition to the...
Robert93 Disconnected tables are just tables with no relationship between them. I have mocked up a solution in attached PBIX below sig. You want Page 8, Table (8) and Table (8a). Basically, split your wire range out into a min and max and then implemented a Complex Selector that you use in your Filters pane.
Measure 8 = VAR __Currentkm = MAX('Table (8)'[km location]) VAR __Minkm = MIN('Table (8a)'[km locations min]) VAR __Maxkm = MAX('Table (8a)'[km locations max]) RETURN IF(__Currentkm>=__Minkm && __Currentkm <= __Maxkm,1,0)
Robert93 Disconnected tables are just tables with no relationship between them. I have mocked up a solution in attached PBIX below sig. You want Page 8, Table (8) and Table (8a). Basically, split your wire range out into a min and max and then implemented a Complex Selector that you use in your Filters pane.
Measure 8 =
VAR __Currentkm = MAX('Table (8)'[km location])
VAR __Minkm = MIN('Table (8a)'[km locations min])
VAR __Maxkm = MAX('Table (8a)'[km locations max])
RETURN
IF(__Currentkm>=__Minkm && __Currentkm <= __Maxkm,1,0)