Hi,
Looking for a a solution in power BI.
When a user select measure from the slicer, Tabular:1 visual should show all members related to the selected measure (which is coming correctly in the model).
Help needed in Tabular 2 visual:
when user select 'CB' Measure from the slicer , then in Tabular 2 the records should show all the members related to 'CB' Measure along with other measure information. example given in Tabular 2
Example
| Slicer (Single select) |
| Measure |
| CB |
| BC |
| AA |
| CCS |
| MRK |
| DC |
| Tabular:1 | | |
| State | Measure | Member |
| MS | CB | M1 |
| MS | CB | m2 |
| MS | CB | m3 |
| MS | CB | m4 |
| Tabular:2 | | |
| Below members should be part/related of CB Measures | | |
| State | Measure | Member |
| MS | BC | M1 |
| MS | AA | M1 |
| MS | CCS | M1 |
| MS | MRK | M1 |
| MS | DC | M1 |
| MS | CCS | M2 |
| MS | MRK | M2 |
| MS | DC | M2 |
