Forum Discussion

TheSAY's avatar
TheSAY
Frequent Visitor
7 years ago

Calculated filter for participants - 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://www.dropbox.com/s/zzkk1r0nv1c7y8i/PBI%20FA%20TEST%202.zip?dl=0

 

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?