The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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:
Solved! Go to Solution.
I manage to work out solution that gives me results I am looking for.
I manage to work out solution that gives me results I am looking for.
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...
@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
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
182 | |
81 | |
64 | |
46 | |
38 |