Count rows of filtered table

[RafaelAri]

The attached Excel file contain original data table ("Table") and the required results table.

This Table contains items qty in 3 warehouses, and qty rented at customers sites.

First, I need to get SUM of WH-qty and Rente- qty, for each item, and then I need to filter items that have "0" for WH-qty AND Rented- qty

I need a DAX measure to get the rows count in the results table.

WH	Item No.	Qty. by WH	Rented Qty.		Item No.	Qty. by WH	Rented Qty.
WH-1	6100020	48	0		8906030	0	0
WH-2	6100020	0	0		8900080-80	0	0
WH-3	6100020	24	0		8900090-80	0	0
WH-1	6100030	54	0
WH-1	6100040	46	0
WH-2	6100040	0	0
WH-3	6100040	8	0
WH-3	8900220	0	0
WH-2	8900220	140	34
WH-1	8900230	60	0
WH-2	8900230	8	40
WH-1	8900400	25	0
WH-2	8900400	17	47
WH-3	8900400	15	0
WH-1	8900410	32	0
WH-2	8900410	2	173
WH-3	8900410	22	0
WH-1	8900420	0	0
WH-3	8900420	2	0
WH-2	8900420	8	121
WH-1	8900430	0	0
WH-3	8900430	15	0
WH-2	8900430	10	44
WH-2	8900430	0	44
WH-1	8904011	3	0
WH-3	8904011	35	0
WH-2	8904011	35	0
WH-3	8906030	0	0
WH-1	8906100	0	0
WH-3	8906100	0	0
WH-2	8906100	0	38
WH-1	8900070-80	0	0
WH-1	8900080-80	0	0
WH-1	8900090-80	0	0

[ryan_mayu · Accepted solution]

@RafaelAri 

should 8900070-80 also be included in the result table?

if so, maybe you can try this

Measure = 
VAR tbl=SUMMARIZE('Table','Table'[Item No.],"WH",sum('Table'[Qty. by WH]),"rent",sum('Table'[Rented Qty.]))
return COUNTROWS(FILTER(tbl,[WH]=0 && [rent]=0))

[RafaelAri]

Thanks ryan_mayu 👍

you are right, 8900070-80 should also be in the results counting

[ryan_mayu]

you are welcome