Total Numbers OrderID over or below average

[mrbajana]

I have a simple data set I need a mesure that counts(Distinct) by each Order ID , 1 if the sales is above the average and 0 if is below average.

Each order have many items, only I need the OrderID counts. The objective is to count how many orders are below or above the average sales in a single card or visual objetcts

Thanks for your help.

Marco 

[mahoneypat · Accepted solution]

Please try this expression patter for a measure in a card visual

Orders Above Average =
VAR __avg =
    CALCULATE ( AVERAGE ( Table[Sales] ), ALLSELECTED ( Table ) )
RETURN
    COUNTROWS (
        FILTER ( VALUES ( Table[OrderID] ), CALCULATE ( SUM ( Table[Sales] ) ) > __avg )
    )

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat