Forum Discussion

PBI5851's avatar
PBI5851
Icon for Helper V rankHelper V
4 years ago
Solved

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...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    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.

v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
4 years ago

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.