Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
@amitchandak @Anonymous @dax @Pragati11 @superDAX @EDW
Solved! Go to Solution.
@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( )
)
)
@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)
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |