Formula Calculation using Rows descriptions

[youssefm9]

Hello,

I need help in calculating the following, would appreciate if you can provide with the formula.

1. sum of COGS (under category column) over Sum of Income (under Type column)

2. sum of COGS (under category column) over Sum of Recurring (under category column)

Category	Type	Month	Month 2	Year	Amount
One-off	Income	31 Jan 2022	Jan-22	2022	$     20,000
Recurring	Income	31 Jan 2022	Jan-22	2022	$     12,000
COGS	Expense	31 Jan 2022	Jan-22	2022	$     10,000
Financial	Expense	31 Jan 2022	Jan-22	2022	$     12,000
Professional	Expense	31 Jan 2022	Jan-22	2022	$       1,200
Online tools	Expense	31 Jan 2022	Jan-22	2022	$       2,320
Travel	Expense	31 Jan 2022	Jan-22	2022	$       1,100
Staff Sales	Expense	31 Jan 2022	Jan-22	2022	$       2,000
Staff Admin	Expense	31 Jan 2022	Jan-22	2022	$       2,000
One-off	Income	28 Feb 2022	Feb-22	2022	$     54,000
Recurring	Income	28 Feb 2022	Feb-22	2022	$     23,000
COGS	Expense	28 Feb 2022	Feb-22	2022	$       1,200
Financial	Expense	28 Feb 2022	Feb-22	2022	$     10,000
Professional	Expense	28 Feb 2022	Feb-22	2022	$       2,300
Online tools	Expense	28 Feb 2022	Feb-22	2022	$       2,300
Travel	Expense	28 Feb 2022	Feb-22	2022	$       4,000
Staff Sales	Expense	28 Feb 2022	Feb-22	2022	$     12,000
Staff Admin	Expense	28 Feb 2022	Feb-22	2022	$       3,000

Thanks.

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[amitchandak]

@youssefm9 , Nor very clear.

measures

M1= sumx(filter(Table, [category] = "COGS" && Table[Type] = "Income") ,[Amount]) 

M2= sumx(filter(Table, [category] = "COGS" && Table[Type] = "Recurring") ,[Amount]) 

[youssefm9]

Hi @amitchandak,

I just want to do 2 formula that returns a value each, given the table i already posted.

1. sum of COGS / Sum of Income

2. sum of COGS  / Sum of Recurring