Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 different ways.
What I want is for my card visual to default to week to date if a user selects day from the slicer but the other visuals to work as normal.
Is this possible without having to create duplicate measures just for the card?
Thanks,
Ben
@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
User | Count |
---|---|
64 | |
59 | |
47 | |
33 | |
32 |
User | Count |
---|---|
84 | |
74 | |
54 | |
50 | |
44 |