Forum Discussion
Solved
Determine Minimum and Maximum Value in Row in Matrix
Hi I am relatively new to power bi I have a dataset that looks as follows Country Supplier Value A Acme 10 A Illuminati 12 A Batman 14 B Acme 20 B Illumi...
Hi,
You can use a MEASURE to do the conditional formatting
Measure = VAR mymin = CALCULATE ( MIN ( Table1[Value] ), ALL ( Table1[Supplier ] ) ) VAR mymax = CALCULATE ( MAX ( Table1[Value] ), ALL ( Table1[Supplier ] ) ) RETURN SWITCH ( TRUE (), SUM ( Table1[Value] ) = mymin, "#FF7F00", SUM ( Table1[Value] ) = mymax, "#2AAAFF" )Now in the Conditional Formatting dialogue
Select as follows
Just one last question :) If i want to count the number of values where supplier is the cheapest or the most expensive how will i go about it.
- Zubair_Muhammad
Community Champion
Hi
I would like to display a seperate matrix or table layed out as follows
Supplier Lowest Values Highest Values Total Values Acme 2 1 3 Batman 1 1 3 Illuminati 0 1 3 - Zubair_Muhammad
You can add these calculated columns
Please see revised file as well
Highest = VAR temp = MAXX ( FILTER ( table1, [Country] = EARLIER ( Table1[Country] ) ), [Value] ) RETURN IF ( [Value] = temp, 1 )Lowest = VAR temp = MINX ( FILTER ( table1, [Country] = EARLIER ( Table1[Country] ) ), [Value] ) RETURN IF ( [Value] = temp, 1 )