Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have tried several times to create measures with the data mart tools provided in the Power BI service
But when I click on the tick button or CR then the code is wiped and all that remains is Sales£ =
When i go to the associated data set and try to use the measure there is no error but the measure returns nulls
What am I missing ?
Solved! Go to Solution.
I tried to create a measure many times yesterday , by typing the formula in different ways and also by using intellisense. But each time I tried to save the formula it was erased. I tried again today by seleting the intellisense again and it saved it right away.
Looks like someone has fixed the problem , so thank you.
Hi @Anonymous
I am so glad to hear that your issue has been fixed , please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
What happens if you just try and create the measure with the following below?
Sales = SUM('Sales_Data'[Sales Amount])
If that does work maybe you need a space between the name and the symbol?
I tried to create a measure many times yesterday , by typing the formula in different ways and also by using intellisense. But each time I tried to save the formula it was erased. I tried again today by seleting the intellisense again and it saved it right away.
Looks like someone has fixed the problem , so thank you.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.