First State with % Value

[kolturra]

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

[kolturra]

Hi,

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

[Anonymous]

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]

Hi,

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

[Anonymous]

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]

hi @kolturra 

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

Thanks!

[Anonymous]

hi @kolturra 

Please try

_fmt_str = CONCATENATE(min('Table'[State]),FORMAT(MIN('Table'[Total]),"0%"))

Thanks!