The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Solved! Go to 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))
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.
Hi,
Try this measure
Measure 2 = coalesce([measure 1],0)
Hope this helps.
@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))