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

Helper V

## Assistance with a bar chart

Hello,

I have two tables as  below.

MainTable

 OrdID OrdDate SalesP OrdStatus A123 5/1/2022 Steve Pending A124 5/2/2022 Jackie Shipped A125 5/3/2022 Steve Complete A126 5/4/2022 Mary Complete A127 5/5/2022 John Complete

outreach table

 OTID OrdID OutType OutDate O123 A125 Phone 5/4/2022 O124 A125 Virtual 5/5/2022 O125 A125 Virtual 5/6/2022 O126 A125 Virtual 5/7/2022 O127 A125 Phone 5/8/2022 O128 A125 F2F 5/9/2022 O129 A125 F2F 5/10/2022 O130 A125 Phone 5/11/2022 O131 A126 F2F 5/4/2022 O132 A126 F2F 5/4/2022 O133 A126 Phone 5/8/2022 O134 A126 Phone 5/9/2022 O135 A126 Virtual 5/5/2022 O136 A127 Virtual 5/6/2022 O137 A127 Virtual 5/7/2022 O138 A127 Virtual 5/8/2022 O139 A127 Virtual 5/9/2022

Main is joined to Outreach by OrdID.  End goal is to display a chart with how many orders have 0, 1, 2, 3 , 4 etc outreach attempts.

So, the x-axis will be 0,1,2,3,4

The y Axis would be 1, 0 ,0 ,0 ,1, 1, 0,0,0 (1 ord had 0 outreach, 0 ord have 2 outreach...., 1 ord had 4 outreach etc).

In order to accomplish this, i used a summarized table and was able to get the numbers, but the ones with 0 outreaches, dont show up.  , since the join to main table missed the missing id in the summarized table.

Any recommendation on how to resolve the sumarized table or any other solution on achieving the goal.

Thank you.

1 ACCEPTED SOLUTION
Community Support

Hi @PBI5851 ,

Please create the table and measure.

``Table = GENERATESERIES ( 0, COUNTROWS ( 'outreach table' ) )``
``````Measure =
VAR tab =
SUMMARIZE (
MainTable,
MainTable[OrdID],
"CountNum", COUNTROWS ( 'outreach table' ) + 0
)
RETURN
COUNTROWS ( FILTER ( tab, [CountNum] = MAX ( 'Table'[Value] ) ) )``````

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support

Hi @PBI5851 ,

Please create the table and measure.

``Table = GENERATESERIES ( 0, COUNTROWS ( 'outreach table' ) )``
``````Measure =
VAR tab =
SUMMARIZE (
MainTable,
MainTable[OrdID],
"CountNum", COUNTROWS ( 'outreach table' ) + 0
)
RETURN
COUNTROWS ( FILTER ( tab, [CountNum] = MAX ( 'Table'[Value] ) ) )``````

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
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.