Measures on a Calculatedtable filtered by slicers

[maserr]

Dear all,

I have been using different measures that are being correctly filtered using slicers. Now I would need several of these measures in a table so I am building a Calculatedtable on my SSAS cube where one of the columns is a different measure in each row. What I find in PBI is that this table is not being filtered as desired, as the measures that are outside the calculatedtable.

Is that behaviour normal? How could I do to achieve it?

Thanks in advance

[AlexisOlson · Accepted solution]

This is normal behavior. Calculated tables are only computed once per time the data is loaded and cannot be responsive to slicers.

Only measures can be responsive to slicers, not calculated columns nor calculated tables (even if they are defined using measures).

[maserr]

Thanks Alexis, would you have any idea to achieve a similar behaviour as the want I need?

[Pragati11]

Hi @maserr ,

This information is not sufficient to answer your query. Can you please put some sample input data along with the desired result expected?

Thanks,

Pragati

[maserr]

 Dear Pragati,

I cannot access to sample date. But here you can see what is happening: my slicers are applying on my measure but not on the calculated table that, at the same time, have the same measure.

[Pragati11]

Hi @maserr ,

Do all your slicer columns (YEAR, MONTH, DATE) exist in Calculated table?

Thanks,

Pragati

[maserr]

No, they don't because what I need is to filter my measure and as I have been reading "CALCULATETABLE function will not work using slicer values, as the tables are generated at the time of model load and hence any slicing post that will not dynamically refresh dependent tables". Which would be the way to achieve exactly this?

Thanks in advance

[AlexisOlson]

You can use the `CALCULATETABLE` function within a measure dynamically but you can't use a measure within a calculated table dynamically.