[jpessoaParticipant Started: 0Replies: 0Total: 0]

This reply has been reported for inappropriate content.

Hello,

You need to first create a measure that calculates de maximum qty:

[MAX] :=CALCULATE(MAX(Table[QTY]);ALL(Table))

After this you just need to count the number of Order_Id’s where Table[QTY]=[MAX]

[COUNT_MAX] = CALCULATE(COUNT(Table[ORDER_ID]);FILTER(Table;Table[QTY]=CALCULATE(MAX(Table[QTY]);ALL(Table))))

I attached an Excel with these 😉

[Author]

Posts