Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
Solved! Go to Solution.
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)
I'm trying to do some calcualtion by creating a new Measure in a dimension named Programs on power bi desktop
if 'Programs'[StartDate] is blank then pick 'Programs'[AltDate] else pick 'Programs'[StartDate]
but in the measure i created under Programs I could access the date columns in my DAX.
I'm connecting power bi live to ssas tabular cube.
Thanks,
I'm trying to do some calcualtion by creating a new Measure in a dimension named Programs on power bi desktop
if 'Programs'[StartDate] is blank then pick 'Programs'[AltDate] else pick 'Programs'[StartDate]
but in the measure i created under Programs I could access the date columns in my DAX.
I'm connecting power bi live to ssas tabular cube.
Thanks,
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?
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.
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.
Regards
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)
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |