Forum Discussion
Advocate IIUSERELATIONSHIP() applied to entire report?
well, you have a lot of measures that return specific values, in case there is only 1 possible scalar value, for example: SELECTEDVALUE(). Whatever tooltip you are using, if it direct to a visual in Power BI that you have put there implicit measures, you can replace them with explicit measures, and than the userelationship will kick in 🙂
You can't do that without a measure, you can't change globally the active relatioship. It's only per measure or group of measures with use of calculation groups
Advocate IIThanks for the quick replies! But - how do I use USERELATIONSHIP() without an aggregation/measure? My report has a "Detail" page that uses a Table visual to display all of the rows from the Fact table that meet my filter criteria. This needs to be row-level detail, not aggregated by dimensions - which means I can't use measures. But I still need for all of the filter criteria to apply, including which date relationship to use.
Perhaps there's a way to construct a measure that doesn't do any aggregation, but simply returns a specific cell (row/column) from the Fact table?
Community Championwell, you have a lot of measures that return specific values, in case there is only 1 possible scalar value, for example: SELECTEDVALUE(). Whatever tooltip you are using, if it direct to a visual in Power BI that you have put there implicit measures, you can replace them with explicit measures, and than the userelationship will kick in 🙂
You can't do that without a measure, you can't change globally the active relatioship. It's only per measure or group of measures with use of calculation groups