Forum Discussion

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

Multiple Use relationship not working

Hello   I am trying to use the below formula and link 2 different use relationship, While I add the 2nd use reltionship the first stop's working Seek support , Let me know if I am doing something ...
jameszhang0805's avatar
jameszhang0805
Icon for Resolver IV rankResolver IV
5 years ago

Please try

CALCULATE (
    COUNTAX ( vw_MSR_CSAT, vw_MSR_CSAT[Primary_CSAT] ),
    USERELATIONSHIP ( vw_MSR_CSAT[Taken on], DimDate[Date] ),
    TREATAS (
        VALUES ( vw_MSR_CSAT[Assignment group] ),
        vw_MSR_Task_Tbl[Assignment group]
    )
)