nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Power Bi - gift amount, gift split amount

Christine Adams

Just started using Power Bi and trying to get a list of donors with their gift totals to certain funds so I would assume I would use gift split amount but in the table it is double counting - is this because I need to the gift.splits.fund.id to the fund.id in the fund table. I thought I did this by connecting the gift ids?

Find more posts tagged with

Microsoft Power Platform

Comments

Christine Adams

Wanted to add - it appears that it totals up the fundraiser credit for each even though I'm not using a fundraiser filter. So if someone gave $200 and they have 3 fundraisers connected to the gift the gift.split total is showing as $600. The Fund.id and campaign.id are both connected to their appropriate fund and campaign IDs on those tables.