Count how often a same order number appears.

Question

Hi people, I hope somebody can help. I think the soulution could be pretty easy, but I couldn't figure it out yet:

I have a column with different and same order numbers. I want to count how often a order numbers appears just one time and how often an order numbers appears multiple times. And then show it in a diagram.

In Excel I would just create a pivot table which count the quantity of how many times a number appears and then I could show the actual number with an "COUNTIF" function.

How could I do it in a efficient way in PowerBi?

Thanks in advance! 🙂

mahoneypat · Accepted Answer

You could try these two expressions&nbsp;Orders One Time =
COUNTROWS (
    FILTER (
        DISTINCT ( Table[OrderNumber] ),
        CALCULATE ( COUNTROWS ( Table ) ) = 1
    )
)

Orders Multiple Times =
COUNTROWS (
    FILTER (
        DISTINCT ( Table[OrderNumber] ),
        CALCULATE ( COUNTROWS ( Table ) ) &gt; 1
    )
)&nbsp;If this works for you, please mark it as the solution.&nbsp; Kudos are appreciated too.&nbsp; Please let me know if not.Regards,Pat

Forum Discussion

Count how often a same order number appears.

2 Replies

Related content

Report not appearing in app

Counting nulls

Field Parameter appear as count

issue count number of matching values.

Count and visualise the number of times an ID appears