Forum Discussion
max value for 2 categories
Hi All,
i am having hard time finding the max value product.
below is my table of data. for argentina 1336 is the max sold value and peripherals is the max sold item.
i am able to get the max sold value with this measure
but i am unable to get the max sold item name which is peripherals i have tried many many dax functions but i am not able to get that. kindly help.
my ultimate result should be for each country one record with max sold item and its value.
amitchandak Anonymous dax Pragati11 superDAX EDW
Anonymous , sorry my mistake, Try like
Rankx(filter(allselected('Sales'[Country], 'Sales'[Product]),'Sales'[Country] =max('Sales'[Country])), CALCULATE(SUM('Sales'[AMOUNT_SOLD])),,desc)
5 Replies
Max Amount Prod = IF( not ISBLANK( [Total Amount] ), CALCULATE( MAX( T[Amount] ), VALUES( Country[Country] ), ALLSELECTED( ) ) ) Max Prod = If( not ISBLANK( [Total Amount] ), var MaxProdAmount = [Max Amount Prod] return CALCULATE( MAXX( FILTER( SUMMARIZE( T, Country[Country], 'Product'[Product] ), [Total Amount] = MaxProdAmount ), 'Product'[Product] ), VALUES( Country[Country] ), ALLSELECTED( ) ) )Anonymous , Based on what I got. Create a rank and apply visual filter for rank =1
Rankx(allselected('Sales'[Country], 'Sales'[Product]), CALCULATE(SUM('Sales'[AMOUNT_SOLD])),,desc)
Anonymous , sorry my mistake, Try like
Rankx(filter(allselected('Sales'[Country], 'Sales'[Product]),'Sales'[Country] =max('Sales'[Country])), CALCULATE(SUM('Sales'[AMOUNT_SOLD])),,desc)