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 might be causing this?
RunningSumMnth =
VAR minimumdate =
CALCULATE (
MIN ( AppendCombinedRunningSumMnth[Date] ),
ALL ( AppendCombinedRunningSumMnth[Date] )
)
VAR totalhour =
CALCULATE (
CALCULATE (
SUM ( AppendCombinedRunningSumMnth[Hours] ),
CROSSFILTER ( AppendCombinedRunningSumMnth[Project Name], df_ProjectSummaryRunningSum[Project Name], NONE ),
AppendCombinedRunningSumMnth[Region_Adj]
= SELECTEDVALUE ( df_ProjectSummaryRunningSum[Region Adj] )
),
FILTER (
ALL ( AppendCombinedRunningSumMnth[Date].[Date] ),
AppendCombinedRunningSumMnth[Date].[Date] >= MIN ( AppendCombinedRunningSumMnth[Date] )
)
)
RETURN
IF (
MIN ( AppendCombinedRunningSumMnth[Date].[Date] ) <= minimumdate,
SUM ( df_ProjectSummaryRunningSum [Remaining Billable Hours] ) - totalhour
)
Page filter selected only 1 item
When Selecting multiple items
It should sum up both values, but it's not doing that. Any idea why is that? All I want is for it to sum up the values for whatever items are selected in the filter. (For example, the Ratable number for December is 2,324.75, and the % Complete number is 2,875.25. When I select both, it should sum up to around 5,200)
Thank you
3 Replies
- Ritaf1983
Super User
Hi Zack92
Please share sample data (excluding sensitive information) in text format, along with your expected result and any relevant logic. For guidance, refer to
How to provide sample data in the Power BI Forum
If possible, upload a simplified .pbix file using this guide:
- Zack92
Helper III
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- calerof
Impactful Individual
657 + 520 = 1177It'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.