measure showing total for entire column

[Anonymous]

hello everyone

i have this measure:

Taxes = SUMX(VALUES('Calendar'[Date]),CALCULATE(CALCULATE(SUM(Expense_Table[Total]),Expense_Table[Expense] = "Financial") * MAX(New_Tax_Rate_Table[Percentage])))

the tax is only applied for financial but when i make a table with all expense, it doesnt seem to work:

 as you see avove, business and hr should not have a tax value and should be blank can you guys help out

[Jihwan_Kim · Accepted solution]

Hi,

Could you please try the below measure whether it suits your requirement?

Taxes =
SUMX (
    DISTINCT ( 'Calendar'[Date] ),
    CALCULATE (
        SUM ( Expense_Table[Total] ),
        FILTER ( Expense_Table, Expense_Table[Expense] = "Financial" )
    )
        * CALCULATE ( MAX ( New_Tax_Rate_Table[Percentage] ) )
)