Forum Discussion
Bfdc
4 years agoFrequent Visitor
Calculated column with measure
Hi All!, I'm trying to get a calculated column depending on the industry type [FILTER table] and a [measure]. The idea is to show that every industry might diffreent waste heat depending on anot...
amitchandak
4 years agoSuper User
Bfdc , the Calculated column can not take slicer value and you should use measure in that.
Try to create a measure and use functions like sumx, minx, Maxx for line-level calculations
Bfdc
4 years agoFrequent Visitor
Thanks for the response Amitchandak!
The isse was that the calculated column couln't take variant data type. So, the measure i guess.
After trying few formulas, the silution I found was more simple. Just added a table in the "report" instead of in the "data" and there your columns can be dependant on a variable.
Btw, nice videos!