Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Folks,,
I am trying to create measure to count numbers of Sunday we have more than 50 order numbers.
When I crate measure using following DAX its showing all rows which have orders (total 149 rows have orders) instead of showing only 15 days where I have more than 50 orders as highlighted.
Number_Of_Sundays = CALCULATE(DISTINCTCOUNT('Date'[Date]),
FILTER(Sales,DISTINCTCOUNT(Sales[Order Number])>50 && RELATED('Date'[Week_Day_Num])=1))
Please correct the mistake I doing. I have attched sample file to this post.
Thanks in advance.
BVK
Solved! Go to Solution.
Thanks alot @Ahmedx fro prompt reply.
Yes, you corrected my mistake. That's exactly what I am looking for. I think I need to think bit more than what I am now.
Thanks again.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |