Forum Discussion

Sabarikumar7579's avatar
Sabarikumar7579
Icon for Helper I rankHelper I
4 years ago
Solved

Summarize with multiple inactive relations and cross filtering visuals not working.

I am trying to summarize total items using inactive relations, which i am able to do separately using "userelationship" function. I have 3 inactive relations to different dimension tables. Everything...
DAX
INACTIVE RELATIONSHIP
USERELATIONSHIP
  • amitchandak's avatar
    amitchandak
    4 years ago

    Sabarikumar7579 , The formula seems correct , Check createddate so not have any timestamp (Change datatype to datetime and use a format with date and check )

     

    Try like

     

     

    CALCULATE (CALCULATE (CALCULATE (
    [Total items],
    USERELATIONSHIP ( Date[Date], DataTable[CreatedDate] )),
    USERELATIONSHIP ( dimAging[OpenAge_Bucket], DataTable[Open_Age_Bucket])),
    USERELATIONSHIP (dimType[Open_type],DataTable[Open_type])
    )

     

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Sabarikumar7579 , The formula seems correct , Check createddate so not have any timestamp (Change datatype to datetime and use a format with date and check )

 

Try like

 

 

CALCULATE (CALCULATE (CALCULATE (
[Total items],
USERELATIONSHIP ( Date[Date], DataTable[CreatedDate] )),
USERELATIONSHIP ( dimAging[OpenAge_Bucket], DataTable[Open_Age_Bucket])),
USERELATIONSHIP (dimType[Open_type],DataTable[Open_type])
)

 

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.