Function to compare Three measures and ghet the highest in terms of units

[yapurnico]

Dear community,

I'm creating a measure that shows the highest between other three measures. But it seems i'm using the wrong Function by using "IF" to compare the trhee measures and ghet the highest measure in terms of units becouse i´m getting a visualization error when i add it to a table whith other measures and columns.
Is there a better Function to compare Three measures and ghet the highest in terms of units??

This is my measure: 

IF(

   [CMC U.Vendidas30d_N2]>[CMC U.Vendidas60d_N2],

   IF(

      [CMC U.Vendidas30d_N2]>[CMC U.Vendidas90d_N2],

      [CMC U.Vendidas30d_N2],

      [CMC U.Vendidas90d_N2]

      )

      ,IF(

           [CMC U.Vendidas60d_N2]>[CMC U.Vendidas90d_N2],

           [CMC U.Vendidas60d_N2],

           [CMC U.Vendidas90d_N2]

          )

)

Thank´s for your time.

[Whitewater100]

Hi: Note Table Constructors  {       }

 = MAXX(
               {
              [Measure 1], 
              [Measure 2], 
              [Measure 3]}
            , [Value]
                         )