Forum Discussion

ctmullins's avatar
ctmullins
Icon for Advocate II rankAdvocate II
4 years ago
Solved

USERELATIONSHIP() applied to entire report?

Hi guys!  Relative newbie here, been working with PBI for the last six months or so, previously coming from a Qlik background.   I have a problem that I'm stumped trying to resolve.  I've scoured t...
Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    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

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

Not sure exactly what you meant by globally, but if you meant you want the option of a toggle that will effect multiple measures at once you can use Calculation Groups.
You will have 2 calculation items:
1. SELECTEDMESURE()
2. CALCULATE(SELECTEDMESURE(), USERELATIONSHIP(...) )

You can also wrap up CI no 2 to only affect / not affect specific measures with an IF condition.

Hope that helps