Product Name as Measure for Highest Sales Product

DAX DAX Calculations
2

Hi Adi,

This is all you need for this one

Top Ranked Product = 
CALCULATE( SELECTEDVALUE( 'Product'[Product Name] ),
    TOPN( 1, ALL( 'Product' ), [Total Sales], DESC ) )

See below for results

image
image.png728×430 16.6 KB

1 Like