Forum Discussion

stefani_vileva's avatar
stefani_vileva
Icon for Resolver II rankResolver II
4 years ago
Solved

Use relationship as measure not working

Hello everyone,   I am struggling with the userelationship function which is not working as I have planed. My model is looking like this: - Products table - which contains all of the details of t...
Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    stefani_vileva 

    Box = 
CALCULATE(
    SELECTEDVALUE(Packages[Name]),
    USERELATIONSHIP(Products[Box ID],Packages[Pack ID]), 
    CROSSFILTER(Products[Box ID],Packages[Pack ID], Both),
    CROSSFILTER(Clients[Product ID], Products[Product ID], Both)
)
SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

stefani_vileva that is another issue 🙂 The reason for the error was what I wrote. I will take a look at your file

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

stefani_vileva 

Box = 
CALCULATE(
    SELECTEDVALUE(Packages[Name]),
    USERELATIONSHIP(Products[Box ID],Packages[Pack ID]), 
    CROSSFILTER(Products[Box ID],Packages[Pack ID], Both),
    CROSSFILTER(Clients[Product ID], Products[Product ID], Both)
)