Forum Discussion

Adi98's avatar
Adi98
Frequent Visitor
4 years ago

Unable to create measure based on slicer

         I have created this visual which shows storage by week of year and a chiclet slicer to select weeks. Now in the visual there is a text box which shows percentage increase or decrea...
Custom Visuals
Data Modeling
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Adi98 , You have to create a measure like

 

new measure =
var _max = maxx(allselected(Date),Date[Week])
var _min = minx(allselected(Date),Date[Week])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[Date] =_max)) - calculate( sum(Table[Value]), filter('Table', 'Table'[Date] =_min))

 

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.