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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.