Forum Discussion

need_help-1324's avatar
need_help-1324
New Member
1 year ago
Solved

a single value for column cannot be determine

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[fieldn...
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    need_help-1324 Try using

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

  • mdaatifraza5556's avatar
    mdaatifraza5556
    1 year ago

    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
  • divyed's avatar
    divyed
    1 year ago

    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's avatar
v-venuppu
Icon for Community Support rankCommunity Support
1 year ago

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.