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
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi GreeshmaN 

Please try the following two versions of the DAX formula and see if they help you.

CALCULATETABLE (
SUMMARIZECOLUMNS (
'fact_A'[prd_id],
FILTER (
'dim_mas_prd',
'dim_mas_prd'[mas_prd_id] = "value"
)
)
)

 

CALCULATETABLE (
SUMMARIZE (
'fact_A',
'fact_A'[prd_id]
),
'dim_mas_prd'[mas_prd_id] = "value"
)

 

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.