Forum Discussion

vijayvizzu's avatar
vijayvizzu
Helper III
4 years ago
Solved

Min Max in Matrix Visual

I write a below dax code to highlight the Min and Max in the current fitler context.It works fine. But now i want to display the min max in splitted with importing country. Means each block of country's landed cost should highlight min max values. Please suggest

Highlighter = 
VAR vTable = 
CALCULATETABLE(
    ADDCOLUMNS(
        SUMMARIZE(
            Consolidated, Consolidated[Supply Country], Consolidated[Supplier], Consolidated[RM Grade], Consolidated[Importing Country]), 
            "@value", [Landed in USD]
    ),
    ALLSELECTED()
)
VAR MinValue = MINX( vTable, [@value])
VAR MaxValue = MAXX( vTable, [@value])
VAR CurrentValue = [Landed in USD]
VAR Result = 
    SWITCH( TRUE(),
    CurrentValue = MinValue,1,
    CurrentValue = MaxValue,2
    )
RETURN
Result 

 

1 Reply