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 o...
Need a help
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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        hi kolturra 

         

        Please create a column using following calculation

         

        DIV = CALCULATE(DIVIDE(SELECTEDVALUE('Table'[Sales]),SELECTEDVALUE('Table'[REvenue])))
         
        Secondly on your Card, pull "_fmt_str" (the measure created earlier) and then add DIV in the filter panel as shown in figure
         

         

        This would give you desired output.

         

         

         

        Thanks!