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
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors