Forum Discussion
Last Year dynamically calculated
Hi there, I'm facing with the following problem. I need to create an Last Year measure. then I created a calculated group like this: v_dim_time and v_fact_sales are related to 1:n var DayTo...
Anonymous
Using ISFILTERED() function you can identify if the column is filtered or not. Based on that, you can switch your logic.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Hi Anonymous ,
Can you please share the sample data and expected output.
Have calculated values where the column changes dynamically i.e shows Total Cost incase Filter in not selected and shows Total Sales if the filter is selected.
The Date Slicer is from the Calendar Table.
Filter =
var __mini = CALCULATE ( MIN ( Dates[Date] ), ALLSELECTED ( Dates[Date] ) )
var __maxi = CALCULATE ( MAX ( Dates[Date] ), ALLSELECTED ( Dates[Date] ) )
var __mind = MIN(Dates[Date])
var __maxd = MAX(Dates[Date])
var __datediffmin = DATEDIFF(__mind,__mini,DAY)
var __datediffmax = DATEDIFF(__maxd,__maxi,DAY)
return
IF ((__datediffmin = 0 || __datediffmax = 0),[Total Sales],[Total Costs])
You can replace the Total Sales and Total Cost with the YTD and YTD from today.
Let me know if this is what you are looking for.
Regards,
Harsh Nathani