How to find quantity sold at specific unit price level?

[cdawidow]

Hey guys, just wondering what dax synthax would be the best to find the quantity sold per product when unit net price = max(unit price)

[AntrikshSharma · Accepted solution]

Try this:

=
VAR MaxUnitPrice =
    MAX ( Table[UnitPrice] )
VAR Result =
    SUMX (
        VALUES ( Table[ProductName] ),
        CALCULATE ( SUM ( Table[Quantity] ), Table[UnitPrice] = MaxUnitPrice )
    )
RETURN
    Result

[amitchandak]

@cdawidow , Try like

calculate(sum(Table[qty]), filter(allselected(Table),Table[product] =max(Table[product]) && Table[product] =max(Table[price])))

Can you share sample data and sample output in table format?

[Pragati11]

Hi @cdawidow ,

Please detai your issue here. It's hard to understand what you are asking.

Refer following link on how to get your questions answered:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Thanks,

Pragati