topic Re: Apply Date Range Filter Based on Condition in DAX Commands and Tips

Apply Date Range Filter Based on Condition

mike_viz_lord — Wed, 03 May 2023 13:10:30 GMT

I'm trying to add a date range filter to my report page based on Created Date. However, the Created Date filter should only apply to Record Type = "B" and return all records where Record Type = "A". So if I selected a Created Date range of 5/1/2023 - 5/3/2023 it would display Record ID's 1, 2, 4, and 5. Any help to implement this would be greatly appreciated!

Record ID	Created Date	Record Type
1	3/1/2023	A
2	3/1/2023	A
3	4/5/2023	B
4	5/3/2023	B
5	5/3/2023	B

Re: Apply Date Range Filter Based on Condition

FreemanZ — Wed, 03 May 2023 13:47:12 GMT

hi mike_viz_lord

you may use this code for further calculations:

VAR _table = UNION( CALCULATETABLE( VALUES(data[Record ID]), ALL(data[Created Date]), data[Record Type]="A" ), CALCULATETABLE( VALUES(data[Record ID]), data[Record Type]="B" ) )

for example, tried to verify like:

Measure = VAR _table = UNION( CALCULATETABLE( VALUES(data[Record ID]), ALL(data[Created Date]), data[Record Type]="A" ), CALCULATETABLE( VALUES(data[Record ID]), data[Record Type]="B" ) ) RETURN CONCATENATEX(_table, data[Record ID], ", ")

it worked like:

Re: Apply Date Range Filter Based on Condition

mike_viz_lord — Tue, 09 May 2023 12:31:38 GMT

Thank you for the reply. Your solution makes sense but I'd like to display a table that contains all columns, not just a card with the measure.