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.
Hi Community,
I'm trying to create measures using variables in Power BI, but in the final result I'm not able to save the result as a numerical value which is not allowing me to aggregate the values. I used format and values both the options.
Please help how to fix this.
Solved! Go to Solution.
Remove the call to FORMAT() as that is what is converting the result to a string. Instead set the formatting of the measure using the Formatting section of the Modeling tab in the ribbon
RETURN
SWITCH(TRUE(),
MAX('P&L MAPPING'[ACC DESCRIPTION])="TOTALVOLLY",FORMAT(TOTALVOL_LY,"###0.##0"),
MAX('P&L MAPPING'[ACC DESCRIPTION])="TOTALGTOLY",FORMAT(TOTALGTO_LY/1000,"###0.##0")
RETURN
SWITCH(TRUE(),
MAX('P&L MAPPING'[ACC DESCRIPTION])="TOTALVOLLY",VALUE(FORMAT(TOTALVOL_LY,"###0.##0")),
MAX('P&L MAPPING'[ACC DESCRIPTION])="TOTALGTOLY",VALUE(FORMAT(TOTALGTO_LY/1000,"###0.##0"))
Hi @Anonymous ,
Please format the value here.
If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Remove the call to FORMAT() as that is what is converting the result to a string. Instead set the formatting of the measure using the Formatting section of the Modeling tab in the ribbon
@Anonymous,
Please provide more details so everyone can help you better.
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |