Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Impactful Individual
5 years ago
Solved

change measure while drill process

hello all,

 

for data like

 
 
i have the following measure
 
Measure = CALCULATE(SUM(Table[Percent]), Table[DateDim] = "Month")
 
For a bar chart i have drill possibility for year / month. When i jump to year I want Table[DateDim] = "Year" instead of Table[DateDim] = "Month". Is that possible?
 
I tried with a filter Table[DateDim] on the canvas and work with SELECTEDVALUE(Table[DateDim]) but had some problems to mark the x-axis with year/month. 
 
thanks.
Need Help