How to take sum of two items and minus one item from row header in power bi matrix table

[RMtechm]

Hi Team,

how to calculate below fomula from attached below table,

Workday

(Monday+Tuesday)-Sunday

(Monday+Tuesday)-Sunday

		actual		Budget
Sunday		10		15
Monday		15		20
Tuesday		35		45

Output:

Workday

40

50

Thanks in advance.

[Kedar_Pande · Accepted solution]

@RMtechm 

Workday Calculation Actual = 
VAR MondayActual = CALCULATE(SUM(Workdays[Actual]), Workdays[Workday] = "Monday")
VAR TuesdayActual = CALCULATE(SUM(Workdays[Actual]), Workdays[Workday] = "Tuesday")
VAR SundayActual = CALCULATE(SUM(Workdays[Actual]), Workdays[Workday] = "Sunday")
RETURN
(MondayActual + TuesdayActual) - SundayActual

Similarly, you can create a budget.

The Card/Table will display the calculated values of 40 for Actual and 50 for Budget.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[RMtechm]

Thanks @Kedar_Pande  for solution it works for me 🙂