Solved: Dax Query for Count and Filter

NandanHegde · ‎02-27-2023

I am leveraging the below DAX query :

EVALUATE VALUES(Date)

This gives me the below output :

How should I modify the query to filter rows with DayOfWeekNm=Sunday.

Also, what is the DAX query to get the count of rows in table Date

----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com