calculate function with a static filter and a dynamic filter

I think you should extract the Revenue into a second table with PowerQuery (aka "Query Editor")

Then the aggregation by Cost Type should immediately work. Reason it does not work that easily now is that your revenue data in same table is messing that up.

Hi RMV,

As the cs_skit posted, you should put revenue values in a new table. I try to reproduce your scenario and get expected result.

1. Create a calculated column to get the month column using the formula.

Month = FORMAT(Test[Date],"MMM")

2. Create a new table including venune value by clicking "New Table" under Modeling on home page, type the formula.

Table = FILTER(Test,Test[Transaction]="revenue")

3. Create a new table to get distinct month.

NewMonth = DISTINCT(Test[Month])

4. Create relationship between the three tables.

5. Create a slicer including NewMonth[Month], create measure using the formula:Percentage = SUM(Test[Amount])/SUM('Table'[Amount])

Please see the following expected result.

Best Regards,
Angelia