problem total sum with a measure

[sandragocj27]

Hi everybody, 

I've got two related tables, and I'm trying to make this measure:

TotalSales = switch(max(Service[ServiceType]);

"A1";[ActualSales];
"A2";[ActualSales];
"A3";[ActualSales]*(1+'Parámeter3'[Parameter A3]/100);
"A5";[ActualSales];
"A5";[ActualSales];
"A6";[ActualSales]*(1+'Parámeter4'[Parameter A4]/100);
[ActualSales])

It works perfectly, but in the total the sum is not correct, any idea?

Thanks a lot!!

[Zubair_Muhammad · Accepted solution]

@sandragocj27

Try with following

What is your firstColumn i.e the Column used to Group Values

TotalSales =
IF (
    HASONEFILTER ( TableName[ColumnusedasRowField] ),
    SWITCH (
        MAX ( Service[ServiceType] ),
        "A1", [ActualSales],
        "A2", [ActualSales],
        "A3", [ActualSales]
            * ( 1
            + 'Parámeter3'[Parameter A3] / 100 ),
        "A5", [ActualSales],
        "A5", [ActualSales],
        "A6", [ActualSales]
            * ( 1
            + 'Parámeter4'[Parameter A4] / 100 ),
        [ActualSales]
    ),
    SUMX (
        VALUES ( TableName[ColumnusedasRowField] ),
        CALCULATE (
            SWITCH (
                MAX ( Service[ServiceType] ),
                "A1", [ActualSales],
                "A2", [ActualSales],
                "A3", [ActualSales]
                    * ( 1
                    + 'Parámeter3'[Parameter A3] / 100 ),
                "A5", [ActualSales],
                "A5", [ActualSales],
                "A6", [ActualSales]
                    * ( 1
                    + 'Parámeter4'[Parameter A4] / 100 )
            )
        )
    )
)

[sandragocj27]

Thanks so much!

[v-chuncz-msft]

@sandragocj27,

By the way, you may help accept solution. Your contribution is highly appreciated.