Forum Discussion

krishanw's avatar
krishanw
Helper II
3 years ago

Calculate If selected string values are True.

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

Need Help

2 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    3 years ago

    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's avatar
      krishanw
      Helper II
      3 years ago
      • 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]"