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
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!

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      hi kolturra 

       

      Did it solve your problem? Please keep us posted and accept solution if it worked!

       

      Thanks!