Display 0 for measure with no value

[mohinderbabu]

Hi PowerBI Gurus,

Hope you all are keeping well.

I have a Measure which calculates Returns% = [No of Returns]/[No of Sales]. when I pull the month from calendar table and measure from another query and put it in a table it shows only the months with data and doesnt display other months. I know there is an option to Show Items With No data. But due to certain limitations I dnt want to use that option and instead want all the months to be displayed with 0% against the month with no data.

Any leads would be apprecaited. Thanks in advance for your time.

[Jihwan_Kim · Accepted solution]

Hi,

Please try something like below whether it suits your requirement.

Returns% = 
        ( [No of Returns]/[No of Sales] ) + 0

[Jihwan_Kim · Accepted solution]

Hi,

Please try something like below whether it suits your requirement.

Returns% = 
        ( [No of Returns]/[No of Sales] ) + 0

[PijushRoy · Accepted solution]

@mohinderbabu 
Or you can use

If(ISBLANK([No of Returns]/[No of Sales]),0,([No of Returns]/[No of Sales]))

If solved, please mark as SOLUTION