Forum Discussion

ad_nan's avatar
ad_nan
Regular Visitor
9 years ago
Solved

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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    According to the error that you are getting and that you are doing this in a measure, then you need to use an aggregator like:

     

    Measure = if(MAX('table'[dim_name]) = "dim1",((if(MAX('table'[dim_name]) = "dim2",'table'[measure]))/(if(MAX('table'[dim_name]) = "dim3",'table'[measure])))/12,5)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

Yes you can but you have to follow DAX syntax. Can you post your formula and sample data and what you are trying to accomplish?

ad_nan's avatar
ad_nan
Regular Visitor
9 years ago

Greg_Deckler

Thanks for quick response.

 

I am trying to implement something similar to this:

 

if('table'[dim_name] = "dim1",((if('table'[dim_name] = "dim2",'table'[measure]))/(if('table'[dim_name] = "dim3",'table'[measure])))/12,5)

 

'/' does not work here. 

 

Thanks.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    According to the error that you are getting and that you are doing this in a measure, then you need to use an aggregator like:

     

    Measure = if(MAX('table'[dim_name]) = "dim1",((if(MAX('table'[dim_name]) = "dim2",'table'[measure]))/(if(MAX('table'[dim_name]) = "dim3",'table'[measure])))/12,5)
  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi ad_nan,

     

    Have you tried the measure provided by Greg_Deckler above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

     

    If you still have any question on this issue, feel free to post here. :smileyhappy:

     

    Regards