Reply to Message

Post Message

Subject

Event summary

Event location

Event street

Event city

Event state

Event country

** Required: Start date

**Required: End date

Event Additional

Event MetaData

Event Status

Body

never-displayed

Hint:

@ links to members

View discussion in a popup

Replying to:

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

FabCon is coming to Atlanta