Forum Discussion
Line Chart Visualization Error
Hello , Im struggling with a line chart report , my target is to display the result between march 2020 and march 2021 , I used this request : LA = CALCULATE([ID INCIDENT(No Blank)],DATESINPERIO...
amitchandak
Super User
Super UserRIMMIMI , does this measure uses +0 or handle is blank
[ID INCIDENT(No Blank)]
refer, +0 in the first var can give all dates. So I handled that remove dates 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))
thank you for your reply , but it didn't work , should I create a unique DAX or create the VARs and make the Calculate Fonction alone ? thank you