Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

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...
Need Help
  • Justas4478's avatar
    Justas4478
    1 year ago

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

    COUNTROWS(SUMMARIZE('Stock Movement','Date'[Date],'Store'[Store Number]))
Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
1 year ago

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's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
1 year ago

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