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

Thanks Greg,

 

Have you usually used MAX function in Power BI like in my situation as well?

Did you try the same function in SSAS Tabular(SSDT) to make measure in it?

 

When Power BI is connected with SSAS Tabular is the same, it doesn't work MAX function even I make report level measure in Power BI.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
No, generally not with SSAS Tabular, just in Power BI Desktop against an imported data set. Although, that is supposed to be SSAS Tabular under the hood so ?

Very strange.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Yes, It is very strange.

    I cannot figure out any clue at all that can make different work.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Could you please review below DAX expression.

       

      TEST_:=
      IF(LASTNONBLANK('FactPayment'[Category], "SUM_PAY_AMT_KRW") , [Payment_KRW (AS-IS)],BLANK())

       

      It makes error in SSAS tabular.

       

      Thanks in advance.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago
        If you are sure that in the context there'll be only one value anyway... why not use SELECTEDVALUE?

        Best
        D