Assistance with a bar chart

[PBI5851]

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.

[v-kkf-msft · Accepted solution]

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.