Dynamic Filtering of derived DAX table based on the filters applied to the source table

---

abhirajkakani wrote:

Hi Sumit,

 

Thanks for the reply. The real problem which i'm trying to solve cannot be solved using a measure. It requires calculated columns and hence it is very necessary for me to get a derived DAX table.

 

I cannot share the real problem for the obvious reasons but measures cannot be used for the operations that i need to perform on the table.

 

 

---

abhirajkakani

Not like measures, calculate columns/tables are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report.

Measure actually may work, I think. You could declare calculated table variable and calculate against the variable, the variable would repsonse to the slicers.

Measure =
VAR tempTable =
    CALCULATETABLE (
        SUMMARIZE ( 'table', 'table'[Name], "TOTAL", SUM ( 'table'[Score] ) )
    )
RETURN
    COUNTROWS ( tempTable )