creating a filtered calculated table

zoubeyrB — Wed, 11 Dec 2024 14:17:55 GMT

Hello everyone,

In my report I have two tables : Date and Sales (not connected to each others).

I added a slicer based on Date[date] and I'm trying to create a calculated table showing only sales with dates former to the date selected from Date.

The following formula works :

FilteredTable = var summarized_ = SUMMARIZE(Sales,Sales[ID_Sale],Sales[ID_Client], "FINAL_SALE_DATE",MAX(Sales[Sales_Date])) var date_ = DATEVALUE("2024-01-01") return filter(summarized_,[FINAL_SALE_DATE] <= date_)

But when I use the selected date I get an empty table :

FilteredTable = var summarized_ = SUMMARIZE(Sales,Sales[ID_Sale],Sales[ID_Client], "FINAL_SALE_DATE",MAX(Sales[Sales_Date])) var date_ = DATEVALUE(LASTDATE('DATE'[Date])) return filter(summarized_,[FINAL_SALE_DATE] <= date_)

I'd appreciate your help on this issue 🙂

Re: creating a filtered calculated table

johnt75 — Wed, 11 Dec 2024 15:49:49 GMT

Calculated tables are only calculated during data refresh, they don't pay any attention to filters or slicers. If you want something to react dynamically you have to use a measure.

Re: creating a filtered calculated table

zoubeyrB — Wed, 11 Dec 2024 16:10:06 GMT

Thanks johnt75 , I added a measure and filtered on it and it worked.

topic Re: creating a filtered calculated table in DAX Commands and Tips

creating a filtered calculated table

Re: creating a filtered calculated table

Re: creating a filtered calculated table