cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TheSAY Regular Visitor
Regular Visitor

Calculated Filter - Wrong Total

Hello,

 

I seem to be having an issue when trying to pull the amount of participants for a report.

 

Here is the link to a ZIP file of the report and source files: https://1drv.ms/f/s!Ar-qf5t6I8TOo0ME1gKSvyjbC_JU

 

There are two reports I run with the membership software we use, and I've been able to get them combined to show the correct amounts per YTD based on the selected month(s) in the slicer.

 

However, if you look at the 2019 Participants column currently there, the "Membership" category is only listing the total as 390. This should be 402 when you add all the numbers up.

 

Are my formulas correct? Why would it not be adding everything up correctly?

2 REPLIES 2
calerof Member
Member

Re: Calculated Filter - Wrong Total

Hi @TheSAY ,

Your measure is correct in each subtotal as well as in the total count.  

The reason is because you have the same member in different categories, those are:

Duplicates.png

 

Regards,

Fernando

 

TheSAY Regular Visitor
Regular Visitor

Re: Calculated Filter - Wrong Total

Hi Fernando @calerof 

 

Thank you for getting back to me.

 

Do you know how I would go about getting duplicates included?  Would I need to base it off the member name and the adjustment type perhaps?

 

For example, with one of the names listed below, Keyla Alberto, they're being duplicated due to "7th Grade Initiative" and "Achievers".  Since the combination of columns will be "Alberto, Keyla-N/A - Unit Level Adjustment" for both, would I need to do it as "Alberto, Keyla-7th Grade Initiative" and "Alberto, Keyla-Achievers"?

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors