Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Total Column Sum of measure

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

Kryssy_0-1673926959432.png

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

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

View solution in original post

3 REPLIES 3
tamerj1
Super User
Super User

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
Not applicable

Thanks Again!!!!!!

SamInogic
Super User
Super User

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/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors