Forum Discussion

ad_nan's avatar
ad_nan
Regular Visitor
9 years ago

Dimension in calculated measure

Hi,

 

Can we use dimension in calculated measures?

 

Also while creating a cal. measure i got an error : 

 

A single value for column 'dimension_name' in table 'table_name' 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.

 

Can anyone help?

 

Thanks,

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi ad_nan,


    Based on error message, I think your measure not summary your columns values,right?
    For measure, it only support to summary values as single value.

     

    You can also take a look at below article:

    When to Use Measures vs. Calc Columns

     

    Regards,

    Xiaoxin Sheng