a single value for column cannot be determine

[need_help-1324]

I am just trying to make simple if statement to capture corresponding value "optionvalue" based on the name "optionname"

I wrote 

RESULT = IF(tablename[fieldname] = "value", sum(tablename[fieldname]))

actual

RESULT = IF(DataImport_Summary[OptionName], = "Entitlements", SUM(DataImport_Summary[OptionValue]))

Thanks for your help in advance

[bhanu_gautam · Accepted solution]

@need_help-1324 Try using

dax
RESULT = IF(
SELECTEDVALUE(DataImport_Summary[OptionName]) = "Entitlements",
SUM(DataImport_Summary[OptionValue]),
0
)

[mdaatifraza5556 · Accepted solution]

Hi @need_help-1324 
Can you please try this DAX.

Result =

    CALCULATE(

        SUM('Table'[OptionValue]),

        'Table'[OptionName] = "Entitlements"

    )

Please accept it as a solution if you got your solution

[v-venuppu]

Hi @need_help-1324 ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.

Thank you.

Regards,

Rama U.

[divyed · Accepted solution]

Hello @need_help-1324 ,

You can use below dax to show desired value in a card : This way your value will be displayed if you click on optionName column

Result =

    CALCULATE(

        SUM('SampleTable'[OptionValue]),

        'SampleTable'[OptionName] = SELECTEDVALUE(SampleTable[OptionName])

    )

I hope this helps.

Did I answer your query ?   Mark this as solution if this helps, Kudos are appreciated.

Kind Regards,

Neeraj

[v-venuppu]

Hi @need_help-1324 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

Regards,

Rama U.

[v-venuppu]

Hi @need_help-1324 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Regards,

Rama U.

[mdaatifraza5556 · Accepted solution]

Hi @need_help-1324 
Can you please try this DAX.

Result =

    CALCULATE(

        SUM('Table'[OptionValue]),

        'Table'[OptionName] = "Entitlements"

    )

Please accept it as a solution if you got your solution

[bhanu_gautam · Accepted solution]

@need_help-1324 Try using

dax
RESULT = IF(
SELECTEDVALUE(DataImport_Summary[OptionName]) = "Entitlements",
SUM(DataImport_Summary[OptionValue]),
0
)