cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## 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.

4 REPLIES 4
New Member

How can I use this measure in a bar chart to show number of items in respective status

Super User

HI @Chaithrar ,

Best Regards,

Pragati Jain

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Proud to be a Super User!!

New Member

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",
[Exception] > 0, "Completed-With Exception(s)",
"Completed"
)

Community Support

You can refer to the following solution.

1.Put the status to a new table

e.g

2.Then create the measure

e.g

``````Switch_measure =
VAR a =
'Table (2)',
"judge",
SWITCH (
TRUE (),
[Sum] >= 10
&& [Sum] < 40, "a",
[Sum] >= 40
&& [Sum] < 60, "b",
[Sum] >= 60, "c"
)
)
RETURN
COUNTROWS ( FILTER ( a, [judge] IN VALUES ( 'Table'[Type] ) ) )
``````

3.Put the status and measure to the related visual

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.