Forum Discussion
Helper IInot getting right values
Super UserHello there luis_pflucker ! Why are you using a calculated column instead of another measure? Try this:
Measure =
var _open = sum(History[_ReTested (RFRT-Assigned) #])
return
SWITCH( _open,
0, "0 reopened",
1, "1 reopened",
2, "2 reopened",
"more than 2")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_pfluckerThanks 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
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
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.