Dax Help

[Anonymous]

Hi Experts,

Below dax measure (Format - Text) is showing percentage in decimals, how we can show the result without decimal part.

This dax measure is created for providing dynamic title for charts.

Please help

Sale % Title =

VAR LABEL = [% OF TOTAL SALE],

RETURN

LABEL 

[Anonymous · Accepted solution]

Hi

Use the FIXED Function, as it can round you to a whole number and also return a string

Sale % Title = FIXED([% OF TOTAL SALE],0,1) 

https://learn.microsoft.com/en-us/dax/fixed-function-dax

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂