APPLY FILTER ON CALCULATED TABLES

[aarshps]

I have created a Calculated table using the max value of my Date dataset. And, I have a slicer on the Date.

I want my Calculated table to be filtered according to the Date slicer that I've been using. But as from I've read, Calculated tables are preprocessed before any slicers are applied.

Is there any other method to create a calculated column?

Can I create a List inside a dataset, or do you guys have any suggestion?

[v-juanli-msft]

Hi @aarshps

Which purpose do you make such trials for?  if you want to show max value of your dataset filtering by a slicer, you can create measures instead.

Best regards

Maggie

[aarshps]

Ya, that's how I have done it. Inside each measure, I've created CalculatedTables and then used them. I was feeling like as I have multiple measures, won't it be costly or something? So I was thinking is there a way to creating a table like a measure, so that I can use it. Actually measure only return scalar values right? Instead is there a way to return a list or something? Also, this list can be used inside multiple measures? Just wanted to make sure, there are no such features available.

[v-juanli-msft]

Hi @aarshps

For your requirement, I would recommend you to have a look at this article which introduces using variables within DAX.

You can use variables to create columns or tables both in measures or calculated columns.

Best Regards

Maggie