measure showing total for entire column

Anonymous — Sun, 16 Oct 2022 16:43:08 GMT

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

Re: measure showing total for entire column

Jihwan_Kim — Sun, 16 Oct 2022 17:00:27 GMT

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

topic Re: measure showing total for entire column in DAX Commands and Tips

measure showing total for entire column

Re: measure showing total for entire column