Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have a measure and a calculated column in the same query. I set the calculated column equal to the measure but when I display the Calculated column in a visual it is blank even though the measure has a value. How can I get the calculated column to contain the same value as the measure? I've placed the example below.
Table1[CalcColumn] = Table1[Measure]
Solved! Go to Solution.
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.
Could 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.
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.