Forum Discussion

AmyD's avatar
AmyD
Icon for Helper I rankHelper I
3 months ago
Solved

M 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...
Need Help
  • MasonMA's avatar
    MasonMA
    3 months ago

    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. 

     

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
3 months ago

Hi AmyD,

 

First of all, DAX and Power Query are two different things.

Second, if you are only able to access the semantic model, can you download the the report?

If you have "" empty strings, does it mean that your data type is string? if that's a yes, proceed with cengizhanarslan's suggestion by creating a new measure. if your data type is number then create a mesaure then call your current measure then add a +0 to it. 

=[current_measure]+0

 

Now.. if you can't add a measure, you can use set a value for blank values in the card itself. "Show blank as" option and put 0. 

 

Hope this helps.