Dynamic count of Sum of part numbers

[WLFRD]

Hello,

I'm struggling with this issue of summing the quantity of part numbers and the 'dynamic calculation' of that quantity when filters are used.

I have this S124 table:

Operator	Part Numbers	Qty	User
35520	S01643840902	0	AA
54459	S01616410026	1	BB
54459	S01616410026	1	BB
54459	S01616410026	0	AA
54459	S01616410026	1	CC
42834	S01336470002	1	CC
58000	S01891440002	1	CC
58000	S01891440003	1	CC
61200	S01774530004	0	AA
25812	S71109850053	2	DD
25812	S71109850112	1	DD
35462	S01780420003	1	DD
38420	S01337620004	0	DD
75548	S01794950011	0	DD
54122	S01946760009	0	AA
25812	S71109850053	0	BB
25812	S71109850112	0	BB
35808	S01630070031	1	CC
35808	S01655400002	4	CC
38420	S01799230115	1	AA
38420	S01799230140	1	BB
42352	S01680500010	3	AA
54122	S01946760009	0	DD
61200	S00965800989	0	DD
61200	S01316450065	5	CC
35808	S01655400002	5	AA
38420	S01799230135	1	AA
42660	S01799230009	1	DD
43860	S01771830002	0	AA
43860	S01771830003	0	BB
44068	S00937360910	0	BB
44068	S00939720962	0	BB
54122	S01634210029	0	BB
55011	S01934430002	0	BB
58001	S01960550006	0	AA
75180	S01764430100	1	AA
75540	S01672790031	1	DD
35462	S01780420003	0	DD
35680	S01731263044	1	CC
35694	S01852540038	1	DD
35694	S01852540038	1	CC

I have tried the Group By in Power Query Editor and it summs the quantity of the parts. Only thing is, the rest of the colomns disappear when closing the Power Query Editor.

Next thing I tried:

This column summs the quantity but isn't recalculated when, for instance, an operator is filtered out. 

What do I need to do to achieve that? 

Thanks in advance.

Regards.

[v-henryk-mstf · Accepted solution]

Hi @WLFRD ,

Try below formula:

count_ = CALCULATE(COUNTROWS('Table'),ALLSELECTED('Table'[User]))

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vanessafvg]

can you provide your expected result?

[WLFRD]

For instance, if User AA is selected, it should count 11 parts.

Same goes for any other option you choose for User and/or operator.