Forum Discussion

fdkza's avatar
fdkza
Frequent Visitor
8 years ago
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...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    fdkza

     

    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

     

     

fdkza's avatar
fdkza
Frequent Visitor
8 years ago

 

  • fdkza's avatar
    fdkza
    Frequent Visitor
    8 years ago

    Zubair_Muhammad

     

    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's avatar
      Zubair_Muhammad
      Icon for Community Champion rankCommunity Champion
      8 years ago

      fdkza

       

      What is your expected output with above data?

      • fdkza's avatar
        fdkza
        Frequent Visitor
        8 years ago

        Hi 

         

        I would like to display a seperate matrix or table layed out as follows 

         

        SupplierLowest Values Highest Values Total Values 
        Acme 213
        Batman113
        Illuminati 013