Total Column Sum of measure

[Anonymous]

Hello All,

Does anyone know how to change the below formula to get the total column to total properly? That is to sum Nov + Dec?
I finally got the column to total (Nov and Dec) however now the total column does not total. 

Here is the formula I used: 

Forecast =

VAR ForecastTable=

    ADDCOLUMNS(

        SUMMARIZE(

                Data,

                Data[Partner & Payment Type]

                ),

        "Rate", [Forecast - Rate],

        "Population", [Headcount Total],

        "FFS", [Forecast - FFS Sum]

    )

RETURN

    SUMX(ForecastTable,

    ([Rate] * [Population]) + [FFS]

    )

[tamerj1 · Accepted solution]

Hi @Anonymous 
Please try

Forecast =
VAR ForecastTable =
    ADDCOLUMNS (
        SUMMARIZE ( Data, Data[Partner & Payment Type], 'Date'[Month] ),
        "Rate", [Forecast - Rate],
        "Population", [Headcount Total],
        "FFS", [Forecast - FFS Sum]
    )
RETURN
    SUMX ( ForecastTable, ( [Rate] * [Population] ) + [FFS] )

[Anonymous]

Thanks Again!!!!!!

[SamInogic]

Hi @Anonymous ,

Can you share sample pbix after removing sensitive data, so that we can check the Total, Nov and Dec column structure in your report?

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/