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're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.