Wrong DAX filtered table

Question

Hi guysCould you please let me know what is wrong with this formula?Mondays = FILTER('Summary Report', RELATED('Calendar'[Weekday])= "Mon")I'm trying to create a table of the Summary Report, but with the dates all on mondaysThe result is all records with tuesdays...not mondays. I've tried to subtract 1 but didn't work....Any ideas?

anonymous · Accepted Answer

It is giving right value as I just recreate the issue at my end. Can you check your calender table Weekday formula, its second parameter should be set to 1.&nbsp;

Forum Discussion

Wrong DAX filtered table

2 Replies

Related content

Wrong Total in Table

Filtered table

Can I filter the 1st fact table which then filters a 2nd fact table?

Filtering Table report

How to search specific word in table filter Calculations