Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 )
)
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
69 | |
64 | |
51 | |
36 | |
26 |
User | Count |
---|---|
85 | |
55 | |
45 | |
44 | |
36 |