Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Setting calculated column equal to a measure

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]                     

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

4 REPLIES 4
nsexton12
Resolver II
Resolver II

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.

Anonymous
Not applicable

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.

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!

Anonymous
Not applicable

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.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.