I am finding that I cannot have UseRelationship() in a Power View report. The issue is that I have a measure that conditionally connects 1 of 2 tables on the fly. Generally that works and I can switch between tables using my slicer field. The problem is that I want to put a filter on the related table, but it only shows filter values when my slicer represents the active relationship in the model.
My guess is that the filters are evaluating independently of the measure and so the Userelationship is not kicking in in time. The same pivot does work in Excel, my report filters do work. Does that make sense and does anyone have a workaround.
- Pete
My guess is that the filters are evaluating independently of the measure and so the Userelationship is not kicking in in time. The same pivot does work in Excel, my report filters do work. Does that make sense and does anyone have a workaround.
- Pete