Issue with Calculations When Selecting Multiple Items on Page-Level Filter

[Zack92]

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 

[Zack92]

@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]

   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.

[Ritaf1983]

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:

 How to upload PBI in Community