Forum Discussion
Post ProdigyCounting 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:
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:
This is the measure I have at the moment:
I manage to work out solution that gives me results I am looking for.
COUNTROWS(SUMMARIZE('Stock Movement','Date'[Date],'Store'[Store Number]))
3 Replies
Justas4478I 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
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...- Justas4478
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.Here is sample file:
https://we.tl/t-Nj1xffZVZm
