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 s...
Anonymous , sorry my mistake, Try like
Rankx(filter(allselected('Sales'[Country], 'Sales'[Product]),'Sales'[Country] =max('Sales'[Country])), CALCULATE(SUM('Sales'[AMOUNT_SOLD])),,desc)
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( )
)
)