Forum Discussion
AmyD
Helper I
Helper IM Formula - Show 0 instead of (blank)
Hi All, Hopefully I've posted this in the right location. I'm after an M code that I can then use on a card to show 0 instead of (blanks). I don't have access to Power BI Desktop - I'm purely wo...
If you have Editing permission you should be able to create DAX Measure in Service after you 'Open Semantic Model'.
A measure like COALESCE([Measure], 0) will work.
tayloramy
Super User
Super UserHi AmyD,
For putting things on cards, you want to use DAX, not M. A measure is what you're after.
You can use the ISBLANK function in DAX to test is a value is blank, and then replace it with something else:
https://learn.microsoft.com/en-us/dax/isblank-function-dax