Calculate If selected string values are True.

[krishanw]

I want to calculate if the work type is equal to "Done" ,"Resolved" or "Verified" then the formula

ex: Work Type = Done or Resolved or Verified then 50*05

[TomMartens]

Hey @krishanw ,

unfortunately, I'm not able to provide some help because I miss information like:

• the selection of the mentioned string values is happening by a (multi)-select slicer
• the selection is happening inside a row context, because you are talking about creating a calculated column
• the expected result is very unclear, as from 50*05 it is not clear what 05 is, if it is a typo and you are meaning 0.5 why you specify a multiplication and not a simple constant
• most importantly you did not specify if you want a calculated column or measure.

Please, provide more information to get your question answered quickly, this also honors the time of all the members in this community.

Regards,

Tom

[krishanw]

• the selection of the mentioned string values is happening by a (multi)-select slicer= values coming from a table it's returning the state of the task 
• the expected result is very unclear, as from 50*05 it is not clear what 05 is, if it is a typo and you are meaning 0.5 why you specify a multiplication and not a simple constant = I mentioned here an example, expecting to return result as below
  "'Efficiency Matrix'[Efficency Rating Total]/[TaskCount]"

  • most importantly you did not specify if you want a calculated column or measure= I want to calculate a measure 

   I want to create a measure if the task state is equal to done, resolved, or verified then this formula "'Efficiency Matrix'[Efficency Rating Total]/[TaskCount]"