Forum Discussion

GreeshmaN's avatar
GreeshmaN
Advocate 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
Super User
1 year ago

Hi GreeshmaN ,

To achieve your goal, please try this DAX:

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