Forum Discussion

dinovic's avatar
dinovic
Frequent Visitor
8 years ago

Alternatives instead of using USERELATIONSHIP

Had an similar issue as the thread below.  

http://community.powerbi.com/t5/Desktop/you-can-t-create-a-direct-active-relationship-between-Survey-and/td-p/182353

So this DAX measure solved my problem for the moment.

=CALCULATE(SUM(InternetSales[SalesAmount]), USERELATIONSHIP(InternetSales[ShippingDate], DateTime[Date]))

However, USERELATIONSHIP dax measure does not work when applying Row Level Security in Power BI web serivce. 

"Couldn't load the data for this visual
The UseRelationship() and CrossFilter() functions are not available in this context."

Is there a lookup function or similar one could use instead?

Thanks
Need Help

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    There is a function called LOOKUPVALUE that might work in your circumstance.