3 Replies Latest reply on Oct 3, 2018 3:54 PM by Shinichiro Murakami

    Row calculation question

    ayden.atharifar

      Hello:

       

      I have a measure that I need to change into a more meaningful data in order to display in a chart that makes sense to the viewer.

      Imagine the field on the left; I created a calculated field, and tried to use LOOKUP and CASE/When or IF/THEN scenarios but all the methods failed.

      I was also unable to use a local variable or a loop in the calculated field.

      Can anyone know of a way to convert the measure on the left to the measure on the right?

      note: the number of rows = '0' or equal to a string value is random.