Forum Discussion
vijayvizzu
4 years agoHelper III
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
I have achieved this.. thank you 🙂
1 Reply
- vijayvizzuHelper III
I have achieved this.. thank you 🙂