Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
kolturra
Helper IV
Helper IV

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

 

 

 

kolturra_0-1623942747720.png

 

6 REPLIES 6
kolturra
Helper IV
Helper IV

Hi,

 

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

 

kolturra_0-1623954404738.png

 

Anonymous
Not applicable

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%"))
 
alekhved_0-1623954362098.png

 

Thanks!

 

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

 

Hi,

 

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

 

Anonymous
Not applicable

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
 
alekhved_0-1623964279000.png

 

This would give you desired output.

 

alekhved_1-1623964304226.png

 

 

Thanks!

Anonymous
Not applicable

hi @kolturra 

 

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

 

Thanks!

Anonymous
Not applicable

hi @kolturra 

 

Please try

 

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.