Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
All,
What am I doing in correctly on the formula below?
% Profiles Started = VALUE ( FORMAT ( DIVIDE ( TotalNumberOfSkills, [Total # Resources] ) * 100, "0.0" ) )
The result of the above is returning a string value.
Am I doing something incorrectly? Is there an alternative to formatting percentages in DAX?
Hi @igordossantos,
You don't need to use DAX functions to format the value of the measure in this scenario. In Power BI Desktop, you can just use Format option under Modeling tab to format the measure as Vvelarde mentioned above.
You can just use the formula below for the measure "% Profiles Started", then follow steps below to change format to Percentage for it.
% Profiles Started = DIVIDE ( TotalNumberOfSkills, [Total # Resources] )
1. Select the measure you want to format on the Fields.
2. Under Modeling tab, just choose Percentage for the Format of the measure.
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |