Forum Discussion

AlpanaSi's avatar
AlpanaSi
Frequent Visitor
4 years ago

Create a variable measure which does not gets affected by a date slicer

Hi All and v-xiaotang 

 

I want to retrieve the last date target value for each sub-category (like 40 for product X and 28.44 for Product Y), in such a way that it is not affected by slicer. My aim is to plot a chart showing three values on combo chart with sub-cateogory on x-axis

actual = 11.32 (X) and 15.33 (Y)

target = 13.32 (X) and 17.33 (Y)

planned = 40 (X) and 28.44 (Y)

 

I put a slicer on combo chart in such a way that the actual and target value varies according to the date but the planned value is a line chart and stays constant, no matter whatever date is chosen on a slicer.

 

CategorySub-CateogoryDateTargetActual
FinancialsRevenue from X Product11/1/202200
FinancialsRevenue from X Product11/1/202313.3211.32
FinancialsRevenue from X Product11/1/202426.680
FinancialsRevenue from X Product11/1/2025400
FinancialsRevenue from Y Product11/1/20221210
FinancialsRevenue from Y Product2/1/202313.3411.34
FinancialsRevenue from Y Product5/1/202314.6412.64
FinancialsRevenue from Y Product8/1/202315.9913.99
FinancialsRevenue from Y Product11/1/202317.3315.33
FinancialsRevenue from Y Product2/1/202418.670
FinancialsRevenue from Y Product5/1/202419.990
FinancialsRevenue from Y Product8/1/202421.330
FinancialsRevenue from Y Product11/1/202422.670
FinancialsRevenue from Y Product3/1/202524.420
FinancialsRevenue from Y Product6/1/202525.770
FinancialsRevenue from Y Product9/1/202527.110
FinancialsRevenue from Y Product12/1/202528.440

1 Reply

  • AlpanaSi ,

    a measure like

    calculate(Sum(planned [planned ]), removefilters('Date'[Date]))

     

    if there is a common date table and plan is there in different table do not join them