wrong tax rate when percentage change and select multiple date

[eliasayy]

Hello everyone,

PBIX file : https://1drv.ms/u/s!Ag9tIyk2ofNRjlBFygNBL3s9VG2N?e=qoIeBc
Excel file: https://1drv.ms/x/s!Ag9tIyk2ofNRjk9-uND6F2ZLZgaZ?e=oAWQzt

I have tax table and expense table

to calculate tax, i need to do tax_rate * total_expense

the tax rate changes on october 1 so look:

on spetmebr 30 :

on october 1 :

when i selectseptemebr 30 and october 1 together, i dont get the correct sum of tax:

 

since 430.08 + 390 = 820.08 not 866.88

have can i fix?

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your datamodel correctly, but please check the below measure.

Taxes =
SUMX (
    SUMMARIZE ( Expense_Table, 'Calendar'[Date] ),
    CALCULATE ( SUM ( Expense_Table[Total] ) )
        * CALCULATE ( MAX ( New_Tax_Rate_Table[Percentage] ) )
)