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
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...

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Whether you can use this function or not depends on the version of the product you use. Please find the documentation and examples of usage here:

    https://dax.guide/selectedvalue/

    Best
    D