Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello All,
I know that similar issue was raised couple times but I didn't find solution to my case or I'm not able to tweak my code.
I'd like to display 0 value on graph when no data are available. I'm calculating PPM measure from Rejected part divided for All parts. When Rejected parts = 0 then nothing appear on graph. I'm trying to use below DAX code to fix it but results isn't sufficient for me:
PPM12M_v2 =
VAR MaxDate =
MAX ( 'DATE_DUP'[WC_Month] )
VAR MinDate =
DATE ( YEAR ( MaxDate ), MONTH ( MaxDate ) - 12, DAY ( MaxDate ) )
VAR PPM =
IF(
ISBLANK((SUMX('PPM returns','PPM returns'[Meters accepted by FE])/SUMX('PPM Despatches','PPM Despatches'[qty]))*1000000),
0,
(SUMX('PPM returns','PPM returns'[Meters accepted by FE])/SUMX('PPM Despatches','PPM Despatches'[qty]))*1000000
)
RETURN
CALCULATE (
PPM,
FILTER ( 'COQ Calendar', 'COQ Calendar'[WC_Month] > MinDate && 'COQ Calendar'[WC_Month] <= MaxDate )
)
Result of above code is below:
Can you help me to fix it ?
Solved! Go to Solution.
@MKPartner , if that is blnak and you want make it 0, Try like
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))
@MKPartner , if that is blnak and you want make it 0, Try like
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))
Thank you for your support. I have tweaked your DAX as below & it works. I didn;t realized to do it by this way.
PPM12M_v2 =
var _1= ((SUMX('PPM returns','PPM returns'[Meters accepted by FE])/SUMX('PPM Despatches','PPM Despatches'[qty]))*1000000)+0
var _max = MAX ( 'DATE_DUP'[WC_Month] )
var _min = DATE ( YEAR ( _max ), MONTH ( _max ) - 12, DAY ( _max ) )
return
CALCULATE(if(max('COQ Calendar'[WC_Month]) <_min || max('COQ Calendar'[WC_Month]) >_max , BLANK(), _1),
FILTER ( 'COQ Calendar', 'COQ Calendar'[WC_Month] > _min && 'COQ Calendar'[WC_Month] <= _max )
)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 66 | |
| 44 | |
| 40 | |
| 29 | |
| 19 |
| User | Count |
|---|---|
| 200 | |
| 126 | |
| 103 | |
| 70 | |
| 53 |