Forum Discussion

DaveCor's avatar
DaveCor
Icon for Helper I rankHelper I
5 years ago
Solved

USERELATIONSHIP - What am I doing wrong?

I've become stuck using USERELATIONSHIP for the first time and I don't understand where I need to plug this into my Dax formula.    I've watched several videos and read numerous posts and articles ...
Need Help DAX
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    USERELATIONSHIP is a filter modifier, you need put it into CALCULATE

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

USERELATIONSHIP is a filter modifier, you need put it into CALCULATE

DaveCor's avatar
DaveCor
Icon for Helper I rankHelper I
5 years ago

I thought I had in my final attempt above but your comment made me look again and figured it out

 

% of Total (AA) = 
DIVIDE( [Total AA], 
    CALCULATE( [Total AA], 
ALL( 'tbl_aa'[AA (Cleaned)] ), USERELATIONSHIP('Calendar'[Date], tbl_mpl[last_closed_date]) ), 
BLANK() )

 

Now my only problem is its not calculating the % correctly but thats a different issue. Thanks for your help