Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply

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 looks great when I visualize them separately. The challenge is when cross-filtering the visuals, The filter doesn't flow to other Tables as they don't have active relations.

I tried using the below function which doesn't work. Even tried replacing Userelationship with "CrossFilter" which dint help.

 

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

 

 This is how my relationship looks:
RelationshipRelationship

Below is my challenge on getting cross-filtering working

Sabarikumar7579_0-1648664137966.png

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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.

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

2 REPLIES 2

Thank you !! @amitchandak 

 

Nested Calculate worked.

amitchandak
Super User
Super User

@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.

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.