Forum Discussion
Setting calculated column equal to a measure
I think I found the resolution. I set another measure equal to the column using the sum function. I was then able to use the two measures in the calculation instead of a measure and a column. I'm sure there is a better way to do this but this works for now.
Resolver IICould you provide the code that you have in the measure? My first inclination would be to copy that code into the calculated column instead of just referencing the measure.
- Measure =CALCULATE('Table1'[sumQuantity],'Table1'[DateReceived] <> " ")The sumQuantity is a measure and the DateRecieved is a column.If I try to use this Measure in the calculation of another measure where I add it to a column I get the error that its not allowed. That is why I was trying to set a calculatedcolumn equal to the measure so that I could use the calculated column in place of the measure.
- nsexton12
Are you wanting to have the same value in every row of the calculated column? Or do you want the calculated column to just show 0 if there is no date received?
A screenshot of your data table/expected outcome would also be great!I think I found the resolution. I set another measure equal to the column using the sum function. I was then able to use the two measures in the calculation instead of a measure and a column. I'm sure there is a better way to do this but this works for now.