PBI Gift Split Query is Pulling in All Package IDs
Hello! My PBI Gift Split query is pulling in every Package ID for the gift appeal into the data, when the data in RE does not have one selected/is null. For Example:
This is my PBI Gift Split Query:

This is the corresponding gift in RE:
- I included the drop-down to show that this gift does not have a package selected, but the two available options are still being pulled into the PBI Gift Split query.
- I believe this is causing my PowerBI to double count this gift (and same for all others of this appeal with no package selected)

Is there a way to fix this in Query or within PowerBI? I am wondering if maybe I should pull Package into my PBI Gift query instead? Any input is appreciated, thanks!
Tagged:
0
Comments
-
You are likely not outputting the correct “Package ID".

the red circle Package section (and the subsequent Package ID you found in there, is the Package that is available to the Appeal, NOT the Package that is selected for the gift (green circle).
0 -
@Alex Wong that was the issue! Thank you!
0
Categories
- All Categories
- New eTapestry Home Community
- New K-12 Community Home (TEST)
- New Higher Education Home Page (Test)
- New Impact Edge Community TEST
- New YourCause Community TEST
- New SKY Community TEST
- New Grantmaking TEST Community
- New Altru Test Community
- New bbcon Community - TEST
- 12 Blackbaud Agents for Good™
- New Raiser's Edge NXT Community
- 8 Blackbaud Community Help
- 223 bbcon®
- 1.4K Blackbaud Altru®
- 411 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.2K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 16 donorCentrics®
- 361 Blackbaud eTapestry®
- 2.7K Blackbaud Financial Edge NXT®
- 688 Blackbaud Grantmaking™
- 604 Blackbaud Education Management Solutions for Higher Education
- 3.3K Blackbaud Education Management Solutions for K-12 Schools
- 954 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 85 JustGiving® from Blackbaud®
- 7.1K Blackbaud Raiser's Edge NXT®
- 4K SKY Developer
- 258 ResearchPoint™
- 124 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 249 Member Lounge (Just for Fun)
- 40 Blackbaud Community Challenges
- 37 PowerUp Challenges
- 3 (Closed) PowerUp Challenge: Grid View Batch
- 3 (Closed) PowerUp Challenge: Chat for Blackbaud AI
- 3 (Closed) PowerUp Challenge: Data Health
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 829 Community News
- 3.1K Jobs Board
- 57 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)

