Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Justas4478
Post Prodigy
Post Prodigy

Counting values for day and week

Hi, I am trying to create count measure that count value per store per day.
While my initial count is working it is counting on to wide level. At the moment it count on SKU level which is not result I am trying to get.
Here is how it looks at the moment:

Justas4478_0-1734098703294.png 
As you at the moment store reiceves deliveries every few days and count is counting how many SKUs delivery is made out of.
While that can be usefull, it is not what I need.
I just need to count if there is delivery on that day count should be 1, if there is next delivery on other day count for that day should be 1 as well and the total count for example in the picture would be 3.
Here is what I am trying to get:

Justas4478_3-1734099516809.png

 

This is the measure I have at the moment:

Stock Movement Picks Count = CALCULATE(COUNTAX('Stock Movement','Stock Movement'[Stock Movement Picks]),'Date'[Week Start Date]

Let me know if you require data sample.
1 ACCEPTED SOLUTION
Justas4478
Post Prodigy
Post Prodigy

I manage to work out solution that gives me results I am looking for.

COUNTROWS(SUMMARIZE('Stock Movement','Date'[Date],'Store'[Store Number]))

View solution in original post

3 REPLIES 3
Justas4478
Post Prodigy
Post Prodigy

I manage to work out solution that gives me results I am looking for.

COUNTROWS(SUMMARIZE('Stock Movement','Date'[Date],'Store'[Store Number]))
Ritaf1983
Super User
Super User

Hi @Justas4478 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

@Ritaf1983 I added sample file.
There is sheet with tables with expected results.
But just incase I will add them to this reply as well.

Justas4478_0-1734341587341.png

Here is sample file:
https://we.tl/t-Nj1xffZVZm 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors