cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ivyhai
Post Patron
Post Patron

Error filtering with many to one to many relationship

I have a many to one to many relationship below. I would like to report the performance between letter activity list (many) and donation (many), but it's not working. 

 

1 Contact can have many letters

1 Contact can have many donations

 

PBI.PNG

PBI.PNG

 

 

1 REPLY 1
AlB
Super User
Super User

Hi @ivyhai 

 

You'd have to explain a bit better what you want. Try this:

1.  fuj_mailingsegmentlists in rows of  matrix visual like you have it

2. This measure in values of the matrix visual:

 

 

Measure =
CALCULATE ( COUNT ( Staging_Donation[DonationId] ), CRM_Letters )

 

It uses the concept of expanded tables:

https://www.sqlbi.com/articles/expanded-tables-in-dax/

https://www.sqlbi.com/articles/context-transition-and-expanded-tables/

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.