Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dax Help!!

Hi,   I'm looking for a DAX formula which can help me get the below mentioned results.   Account Name Country Revenue   XYZ Singapore 1000 Ignore This XYZ Thailand 800 Ignore Th...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous ,

    new column =
    var _max = maxx(filter(Table, [Account Name] = earlier([Account Name])),[Revenue])
    return
    if( [Revenue] =_max, [Country],blank())

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try like

new column =
var _max = maxx(filter(Table, [Account Name] = earlier([Account Name])),[Revenue])
return
if( [Revenue] =_max, "Consider this", "Ignore This")

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amitchandak ,

     

    Thank you for your swift response.

     

    I'm looking for the result as below:

     

    Account NameCountryRevenueCountry_Result
    XYZSingapore1000 
    XYZThailand800 
    XYZVietnam900 
    XYZSri Lanka1200Sri Lanka
    ABCSingapore400Singapore
    DEFPhilippines200Philippines

     

    If the the critiria isn't matching, I should get a blank else the Country name.

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      Anonymous ,

      new column =
      var _max = maxx(filter(Table, [Account Name] = earlier([Account Name])),[Revenue])
      return
      if( [Revenue] =_max, [Country],blank())