Inserting 0 or $0 instead of empty cell

[lastnn30]

Hi

I created this martix (see below please). SalesPerson Chin did not have any sales for month of March. want Power BI inseting 0 or $0 instead of nothing. Thank you very much.

 

[Anonymous]

Hi @lastnn30 , 

Please refer to the following pbix file to see if it helps you.

Create a measure.

Measure =
VAR max_ =
    SUM ( 'Table'[value] )
RETURN
    IF ( ISBLANK ( max_ ), 0, MAX ( 'Table'[value] ) )

If I have misunderstood your meaning, please provide your desired output and your pbix file without privacy information.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

Try this measure

Measure 2 = coalesce([measure 1],0)

Hope this helps.

[amitchandak · Accepted solution]

@lastnn30 , usually adding +0 to measure can help

Sales new =[Sales] +0

Sometimes it can give a lot many values, then you can try to force range again

0 between range
Measure = var _1= SUM(Opportunity[Opportunity count]) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))