How to Count number of Sundays more than X Orders?

[itsmebvk]

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.

Sample FIle Attached 

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

[Ahmedx · Accepted solution]

Is this what you are looking for?

[itsmebvk]

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.