topic Re: First State with % Value in DAX Commands and Tips

First State with % Value

kolturra — Thu, 17 Jun 2021 16:16:41 GMT

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

Anonymous — Thu, 17 Jun 2021 17:22:38 GMT

Please try

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

Thanks!

kolturra — Thu, 17 Jun 2021 18:26:52 GMT

Hi,

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

Anonymous — Thu, 17 Jun 2021 18:27:42 GMT

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 — Thu, 17 Jun 2021 18:36:08 GMT

Hi,

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

Anonymous — Thu, 17 Jun 2021 21:11:52 GMT

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 — Fri, 18 Jun 2021 20:08:46 GMT

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

Thanks!