Forum Discussion
Issue with Calculations When Selecting Multiple Items on Page-Level Filter
Hey, I’m running into an issue where some calculations aren’t working properly when I select multiple items on the page-level filter [df_ProjectSummary[Project Rev Rec Type]]. Does anyone know what m...
Ritaf1983
In the sample file, if you pick "% Completed" on the Project Rev Rec Type filter, you'll see the value for December 2024 is 657 for the NA Region. If you choose "Ratable," it shows 520 for the same region and month. But if you select both (% Completed and Ratable), the total should be 1,190 (the sum of both values). Instead, it's showing 1,177. I was hoping it would show 1,190 as the correct total. Any help would be appreciated! Thanks!
Sample File
https://drive.google.com/file/d/1FuasuHGtYHjF2FfKZmM5hOC80kD4qpZ8/view?usp=sharing
657
+ 520
= 1177
It's important that you uncheck the auto date/time checkbox in Options and create your own Calendar table.
I'd also suggest to optimize your model and check how the tables are related to each other.