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
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:
CALCULATE ( COUNT ( Staging_Donation[DonationId] ), CRM_Letters )
It uses the concept of expanded tables:
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!