Forum Discussion
Replace blank with zero value in Matrix visual when data not available
Hi All, Need an urgent help for my Power BI dashboard. In matrix visualization format, I have to show average billable hours against employees under various departments against every date ( cloum...
sdas1 , Try measure like , summing current measure is m1
0 between range
Measure = var _1= [M1] +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))