Forum Discussion

Zack92's avatar
Zack92
Icon for Helper III rankHelper III
1 year ago

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 
    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's avatar
      calerof
      Icon for Impactful Individual rankImpactful Individual

       

       

         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.