Solved: Dax Help

Anonymous · ‎09-28-2022

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 · ‎09-28-2022

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)

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

Anonymous · ‎09-28-2022

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)

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

Dax Help