Forum Discussion
SummarizeColumns with Calculatedtable is not working as expected
Hello, I have a fact table called fact_A and a dimension table called dim_mas_prd. I am using summarizecolumns with caluculatedtable functions in the cascading parameters for the paginated report ...
Hi GreeshmaN ,
Try Using FILTER Instead of Direct Condition in CALCULATETABLE:
CALCULATETABLE (
SUMMARIZECOLUMNS ( 'fact_A'[prd_id] ),
FILTER ( ALL ( 'dim_mas_prd' ), 'dim_mas_prd'[mas_prd_id] = "value" )
)
The above logic doesn't filter the data. There is some issue between Calculatetable & Summarizecolumns when both used together.