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 not summing

Hello,

I am trying to do a simple formula = Total * Rate. However, the total in the row does not work. Does anyone know how to change the formula so it totals properly, please?

I understand its using the total percentage to multiple the total total, but I am not sure how to change it to get the total in the row. Help please

 

Here is the formula I am using: 

Test =
    IF(
        HASONEVALUE(Dates[Date]),
        [Rate] * [Total] ,
            SUMX(Dates,
             [Rate] * [Total]
             ))

 

Kryssy_2-1673839553553.png

 

 

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Anonymous 
Please try

Test =
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[Name],
        Dates[Date]
    ),
    [Rate] * [Total]
)

View solution in original post

3 REPLIES 3
tamerj1
Super User
Super User

Hi @Anonymous 
Please try

Test =
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[Name],
        Dates[Date]
    ),
    [Rate] * [Total]
)
Anonymous
Not applicable

Thank you very much!!!!!

AlexisOlson
Super User
Super User

You can iterate over companies instead of dates and/or you could fix your [Rate] measure. Rates aren't generally additive, so the 6.00% in the total row doesn't make sense.

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