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
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
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Anonymous 

         

        Do you have experience that worked the SELECTEDVALUE function in SSAS?

         

        Do you mean my expression: 

         

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

         

        change into like below...?

        IF(SELECTEDVALUE('FactPayment'[Category], "SUM_PAY_AMT_KRW") , [Payment_KRW (AS-IS)], BLANK())

         

        I do not have any knowledge with the function, if my expression with SELECTEDVALUE is wrong, please correct it.

         

        I tried MAX, LASTNONBLANK, FIRSTNONBLANK... but all of the function made error in SSAS...