Forum Discussion

Bfdc's avatar
Bfdc
Frequent Visitor
4 years ago

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 another factor which is not going to be selected by the user (temperature)

 

 

So, as columns cannot call measures, is there a way to show a matrix/graph with different measures depending on one filter and one measure? Am I missing any DAX function here?

Hope this makes sense to you 🙂 THANKS

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Bfdc
      Frequent Visitor
      4 years ago

      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!