Forum Discussion
Converting measure into calculated column
Hi, I am having issue to use measure in chart , filter visuals. Measure is giving me the correct result but I need to use it as bar chart, how to convert measure to calculated column.
Pragati11
Super User
Super UserHI Anonymous ,
Can you share your measure definition here please?
Thanks for responding.
I have individaul measures where the calculation has been done and then there is a "Overall Status" measure where I am using Switch to use individual measures to return the result.
Overall Status =
SWITCH
(
TRUE(),
[Blank Type] > 0, "Template Missing",
[Missing Criteria] > 0, " Criteria Missing",
[Blank Due Date] > 0 , "Task(s) Missing",
[Overdue] > 0 , "Overdue",
[ Plan Overdue] > 0 , " Plan Overdue",
[ Plan Found] > 0 , " Planned",
[Due In 2 Weeks] > 0 , "Due in 2 Weeks",
[Due In 4 Weeks] > 0 , "Due in 4 Weeks",
[Due After 4 Weeks] > 0 , "Due after 4 Weeks",
[Incomplete] > 0, "Gateway Key Task(s) Incomplete", -- Incomplete Key Task
[Exception] > 0, "Completed-With Exception(s)",
"Completed"
)