Forum Discussion

kolturra's avatar
kolturra
Helper IV
5 years ago

First State with % Value

Hi,

 

i have table like this in which i want to reprsent first value of state name and concentnate with Total %

 

California 18.76%

 

Please note that Total % calculaation is comming from DAX on top of it, i need to achieve this. Please help

 

 

 

 

Need a help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    hi kolturra 

     

    Please try

     

    _fmt_str = CONCATENATE(min('Table'[State]),FORMAT(MIN('Table'[Total]),"0%"))
     
    Thanks!
  • kolturra's avatar
    kolturra
    Helper IV
    5 years ago

    Hi,

     

    Can you please see the below screenshot and help. i should display in card with Max % value

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      hi kolturra 

       

      Here you go

       

      _fmt_str =
      VAR DIV = CALCULATE(DIVIDE(SELECTEDVALUE('Table'[Sales]),SELECTEDVALUE('Table'[REvenue])))
      var sta = CONCATENATE(MIN('Table'[State])," -")
      RETURN
      CONCATENATE(sta,FORMAT(DIV,"0%"))
       

       

      Thanks!

       

      PS: Kindly accept the solution! I would love to have Kudos! 🙂

       

      • kolturra's avatar
        kolturra
        Helper IV
        5 years ago

        Hi,

         

        Thanks but we need max % value details in card. can you also please help with that DAX