Forum Discussion
Filter different visuals on same selected value but from different dimensions
Here is the solution that worked for me:
1. Create a separate lookup dimension that contains all the values for Region. In my case there was a dimension table available in the data warehouse.
2. Create inactive relationships between the RegionCode in the lookup dimension and the RegionCode values in the Reseller, Customer and Manager dimensions.
3. Add a slicer based on the Region lookup dimension to the report. Note that the relationships above need to be inactive because if they are active relationships, the lookup slicer will filter all three dimensions at once where we actually want to filter only one of the three for each measure.
4. Create custom measures that use the USERELATIONSHIP filter to filter the measure by only one of the three relationships, leaving the other two inactive.
5. Use these measures in the report. Generally this type of report would be high level report showing just a few important cards or KPIs based on these measures. In my case this report will primarily be a portal-type report that provides links to separate reports that show details for measures related to Managers, Customers or Resellers for this region.
Here is the solution that worked for me:
1. Create a separate lookup dimension that contains all the values for Region. In my case there was a dimension table available in the data warehouse.
2. Create inactive relationships between the RegionCode in the lookup dimension and the RegionCode values in the Reseller, Customer and Manager dimensions.
3. Add a slicer based on the Region lookup dimension to the report. Note that the relationships above need to be inactive because if they are active relationships, the lookup slicer will filter all three dimensions at once where we actually want to filter only one of the three for each measure.
4. Create custom measures that use the USERELATIONSHIP filter to filter the measure by only one of the three relationships, leaving the other two inactive.
5. Use these measures in the report. Generally this type of report would be high level report showing just a few important cards or KPIs based on these measures. In my case this report will primarily be a portal-type report that provides links to separate reports that show details for measures related to Managers, Customers or Resellers for this region.