Forum Discussion

Preetish_1's avatar
Preetish_1
Helper I
9 years ago
Solved

Dynamic Measures based on filtering

      Hello everyone, The red target line in the above visual is calculated using the following Measure.   Target = var FirstDt = FIRSTDATE(T1[C_FullDate].[Date]) var Targ = CALCULATE...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Preetish_1,

     

    If I understand you correctly, the formula below should work in your scenario. :smileyhappy:

    Target =
CALCULATE (
    DIVIDE ( SUM ( T1[Target %] ); COUNTROWS ( T1 ) );
    ALLSELECTED ( T1[C_FullDate] )
)

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Preetish_1,

 

If I understand you correctly, the formula below should work in your scenario. :smileyhappy:

Target =
CALCULATE (
    DIVIDE ( SUM ( T1[Target %] ); COUNTROWS ( T1 ) );
    ALLSELECTED ( T1[C_FullDate] )
)

 

Regards