Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

MAX function with Text column doesn't work in Live Connection SSAS Tabular

Hi Experts,   I have a trouble using DAX function: MAX. I want to get a unique value from Text column to use switch to use different calculation for each category in one measure.   In Power BI D...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

the way you wrote it, you perhaps tried to do this instead

 

e.g. Measure = IF(MAX('Table'[TextColumn]) = "A", Value, Blank())

 

there was an extra ")"

 

don't know if it helps

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I'm sorry I put wrong express in my post, I surely used correct expression that works in Power BI without SSAS.

    like you corrected.

    e.g. Measure = IF(MAX('Table'[TextColumn]) = "A", Value, Blank())

     

    Therefore, the error is not from ")"

     

    Thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Based on my test using Power Bi version : 2.80.5803.1061 64-bit .I cannot reproduce your issue here. Could you please update your Power bi desktop and check again?

     

     

    Or we can try this formula.

    IF(value('Table'[TextColumn]) = "A", Value, Blank())

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for your kind reproduce with image, Frank.

       

      However my issue is when I'm working with SSAS live connect, not just Power BI alone.

      The same DAX expression works in Power BI, but when the data comes from SSAS tabular mode in Live connection, the expression makes error.

       

      Looks weird.