Calculated Row

[Anonymous]

Hello good people,

Need your help. 

I have the following table. 

All the columns are calculated columns. I want to have a "Total" which excludes "Gross Profit". Currently it is counting the "Gross Profit" inside the "Total". I want to keep it excluded. Please help.

[amitchandak]

@Anonymous , Try like

Total New =calculate([Total],Table[MOH COA Level 6]!="Gross Profit")

or

Total New = if(isfiltered(Table[MOH COA Level 6]),[Total],calculate([Total],Table[MOH COA Level 6]!="Gross Profit"))

refer
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

[Mariusz · Accepted solution]

Hi @Anonymous 

You can adjust the below Measure to get the required result.

Sales Total without Contoso = 
VAR __totalWithoutContoso = 
    CALCULATE(
        [Sales],
        KEEPFILTERS( 
            NOT 'Product'[Brand] = "Contoso" 
        ) 
    )
RETURN 
IF(
    HASONEVALUE( 'Product'[Brand] ),
    [Sales],
    __totalWithoutContoso
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Thanks a lot man. Your solution is precise and to the point 😀