Forum Discussion

Ben81's avatar
Ben81
Icon for Helper I rankHelper I
3 years ago

Override slicer for specific visual

Hi,   I have a card visual with a measure value which can be changed by a slicer between previous day, week to date, month to date etc.. and I have other visuals that show the same measure but in d...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Ben81 , Try measures like

 

WTD based on the selected date or today

 

WTD =
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min = _max -WEEKDAY(_max,2)+1
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

 

 

WTD of full data

WTD =
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min = _max -WEEKDAY(_max,2)+1
return
 if(isfiltered('Date'), CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max)), [net])

 

where [net] is my measure