Forum Discussion
Si_7777
Advocate II
Advocate IIDAX help - counting single item lines
I have measure to count PO's with single items It kinda works but doesnt sum per day / week / per year My measure is ; 1 Items per PO = CALCULATE(COUNTROWS(Sage_POPOrderRetu...
Hi Si_7777 , Thank you for reaching out to the Microsoft Community Forum.
We took sample data based on your scenario and recreated your matrix structure with Year -> Date -> PO Number. We rewrote the 1 Items per PO measure to first identify POs that have exactly one distinct item, then count them in the current filter context. This ensures the count is accurate at PO, daily and yearly levels without double-counting.
Please check the attached .pbix file for your reference and share your thoughts.
Thank you.
v-hashadapu
Community Support
Community SupportHi Si_7777 , Hope you are doing well. Kindly let us know if the issue has been resolved or if further assistance is needed. Your input could be helpful to others in the community.