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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.