Want Sum invoice amounts for which we received payment

[ShantanuBakare]

have folloiwng data set

I want sum of Balance amount which got paid in Wk1, i.e. invoices which were in Wk1 and are not in Wk2.

Week No	Business Unit	invoice number	Invoice Type	Bucket	Balance Amount
Wk1	BFS-UK	INV001	Overdue	[0-30]	100
Wk1	SWITZERLAND	INV002	Overdue	[46-60]	100
Wk1	BFS-UK	INV003	Overdue	[31-45]	100
Wk1	BFS-UK	INV004	Overdue	[46-60]	100
Wk1	BFS-NA	INV005	Overdue	[0-30]	100
Wk1	SWITZERLAND	INV006	Overdue	[0-30]	100
Wk1	SWITZERLAND	INV007	Overdue	[46-60]	100
Wk1	BFS-NA	INV008	Overdue	[31-45]	100
Wk1	SWITZERLAND	INV009	Overdue	[0-30]	100
Wk1	SWITZERLAND	INV010	Overdue	[46-60]	100
Wk1	SWITZERLAND	INV011	Overdue	[31-45]	100
Wk1	BFS-UK	INV012	Overdue	[46-60]	100
Wk1	BFS-NA	INV013	Overdue	[0-30]	100
Wk1	BFS-NA	INV014	Overdue	[46-60]	100
Wk1	BFS-NA	INV015	Overdue	[46-60]	100
Wk2	BFS-UK	INV004	Overdue	[31-45]	100
Wk2	SWITZERLAND	INV005	Overdue	[0-30]	100
Wk2	BFS-UK	INV006	Overdue	[46-60]	100
Wk2	BFS-UK	INV007	Overdue	[31-45]	100
Wk2	BFS-NA	INV008	Overdue	[46-60]	100
Wk2	SWITZERLAND	INV009	Overdue	[0-30]	100
Wk2	SWITZERLAND	INV010	Overdue	[0-30]	100
Wk2	BFS-NA	INV011	Overdue	[46-60]	100
Wk2	SWITZERLAND	INV012	Overdue	[31-45]	100
Wk2	SWITZERLAND	INV013	Overdue	[46-60]	100
Wk2	SWITZERLAND	INV014	Overdue	[0-30]	100
Wk2	BFS-UK	INV015	Overdue	[0-30]	100
Wk2	BFS-NA	INV016	Overdue	[46-60]	100
Wk2	BFS-NA	INV017	Overdue	[46-60]	100
Wk2	BFS-NA	INV018	Overdue	[46-60]	100

I want sum of invoices which have got paid in Wk1 (Week1) for above (Dummy) data I should get sum of 'Balance Amount' for invoice number INV001, INV002 and INV003 as these invoices are not there in Wk2 (Week2) Also need sum of 'Balance Amount' for INV016, INV017 and INV018. Can someone help me build two separate DAX measures. I want to put this Sum in matrix, so that it can be devided in Bucket.

[amitchandak]

@ShantanuBakare , Create measures for Week 1 and week 2

example

Paid = countx(filter(values(Table[Invoice Number]) , not(isblank([Week1])) , isblank([Week2])),[Invoice Number])

where

Week1 = calculate(sum(Table[Bal Amount]), Filter(Table, Table[Week No] ="Wk1"))

Week2 = calculate(sum(Table[Bal Amount]), Filter(Table, Table[Week No] ="Wk2"))

if you have date and want to calculate WOW

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8

[ShantanuBakare]

Hi Amit, Thanks for answering my quesiton. while entering 'Paid' I am getting following error. 

Too many arguments were passed to FILTER funtion. The maximum argument count for the function is 2.

[ShantanuBakare]

I want sum of 'Balance Amount' which are paid in Wk1. That is invoices which were present in Wk1 are not present in Wk2.