Forum Discussion

luis_pflucker's avatar
luis_pflucker
Icon for Helper II rankHelper II
4 years ago

not getting right values

Hi,  I am trying to calculate a column based in a measure but not getting as I want: Measure = sum(History[_ReTested (RFRT-Assigned) #]) Column 2 = if([Measure]=0,"0 reopened",if([Measure]=1,"1...
luis_pflucker's avatar
luis_pflucker
Icon for Helper II rankHelper II
4 years ago

Thanks Gonçalo, it helped, but with a measure i am not able to build a clustered chart, because is no way to put this measure in legend:

 

goncalogeraldes's avatar
goncalogeraldes
Icon for Super User rankSuper User
4 years ago

Hello there luis_pflucker ! SInce that is the case, use a "Calculated Column" with the same formula and I think you can get your desired result.

 

Hope this answer solves your problem! If you need any additional help please @ me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

  • luis_pflucker's avatar
    luis_pflucker
    Icon for Helper II rankHelper II
    4 years ago

    Hi Goncalo,

    I tried but no getting as I want, calculated column is:

    _ReTested (RFRT-Assigned) # = if(and(History[History New Value]="Assigned",History[History Old Value]="Ready_for_ReTest"),1,0)
    It is counting  but not differentiate 2 reopens, 1 reopens, etc.