Forum Discussion

GreeshmaN's avatar
GreeshmaN
Icon for Advocate I rankAdvocate I
1 year ago

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 ...
General Comment
Need Help
Show and Tell
Bibiano_Geraldo's avatar
Bibiano_Geraldo
Icon for Super User rankSuper User
1 year ago

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" )
)
GreeshmaN's avatar
GreeshmaN
Icon for Advocate I rankAdvocate I
1 year ago

The above logic doesn't filter the data. There is some issue between Calculatetable & Summarizecolumns when both used together.