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
For the below one:

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

I am getting an error message: Query (9, 5) A single value for column 'prd_id' in table 'fact_A' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
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.