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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Jason2500
Helper I
Helper I

How to get decimals from the DAX measures?

Hi 

 

I have below DAX measures

 

Indicator KPI = SWITCH(SELECTEDVALUE('Table'[Type]), "NS", [SVL], "GPS", [GP])
 

SVL = SUM('TABLE1[HT]')

GP = [jk] / [sales]

 

The output of indicator KPI gives 0.56  I need to get the value is 56.25.

 

How to get the decimal points? I tried with Format option in the tab but not working

 

Please advise

 

 

 

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@Jason2500 

Not clear enough but you can multiply by 100 or format the measure as %.

 

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂


Website YouTube  LinkedIn

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

1 REPLY 1
Fowmy
Super User
Super User

@Jason2500 

Not clear enough but you can multiply by 100 or format the measure as %.

 

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂


Website YouTube  LinkedIn

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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