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

All of your solutions work, but my concern is the function that I shared with Summarizecolumns used to filter the data but its not filtering the data.

Would like to know if there is any issue with Summarizecolumns and calculatetable, as it worked before.

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Icon for Super User rankSuper User
1 year ago

Hi GreeshmaN ,

The issue seems to be related to how SUMMARIZECOLUMNS and CALCULATETABLE interact. While SUMMARIZECOLUMNS creates a summarized table, VALUES returns distinct values, and they may behave differently in certain contexts. The problem might stem from changes in the data model or filters not being applied correctly. If the filter 'dim_mas_prd'[mas_prd_id] = "value" isn’t working, it can prevent SUMMARIZECOLUMNS from filtering the data. To diagnose the issue, try testing the filter alone with CALCULATETABLE without SUMMARIZECOLUMNS to see if it works:

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

If this works, the issue might lie in the way SUMMARIZECOLUMNS is interacting with the filter. Check if there are any changes in your data model or relationships that could affect the filter.