cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III

Dynamic count of Sum of part numbers

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?

Regards.

1 ACCEPTED SOLUTION
Community Support

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.

3 REPLIES 3
Community Support

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.

Super User

can you provide your expected result?

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Helper III

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.