Forum Discussion

Varshi288's avatar
Varshi288
Icon for Resolver II rankResolver II
6 years ago
Solved

Measure showing wrong results afer adding 2020 data.

Hi every one hope all are doing well. I am facing  with measure

I have a measure 2 measures SP incr % and TP incr % with  date slicer to  select between two dates. Both were working fine till last month. After adding  Jan 2020 data , SP incr % working in weirdly. If I select date slicer from 1st Feb 2019 to  till date  all values as showing -100% which is wrong.If I select before Feb 2019 date it it working fine. Can any one suggest what could be wrong

Below are the measures used in calcuation

SP incr =SUMX(PriceImpact,(1-MIN(2,MAX(DIVIDE([MP PrY (SP)],[MP (SP)]),0.5)))*[SP_price increase])
TP incr =SUMX(PriceImpact,(1-MIN(2,MAX(DIVIDE([MP PrY (TP)],[MP (TP)]),0.5)))*[TP_price increase])
TP incr % = DIVIDE([TP incr],[Cov TP]-[TP incr])
SP incr % = DIVIDE([SP incr],[Cov SP]-[SP incr])

 

 

 

 

  • Hi Az38,

     

       You are right.one of the measure was wrong. This is sorted now. Thanks. 

2 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion

    Hi Varshi288 

    what is [Cov TP]? [Cov SP]? [MP PrY (SP)]? [MP PrY (TP)]? [SP_price increase]? [TP_price increase]? measures?

     

    if so, what statements are define these measures?

    the issue is somewhere around

    • Varshi288's avatar
      Varshi288
      Icon for Resolver II rankResolver II

      Hi Az38,

       

         You are right.one of the measure was wrong. This is sorted now. Thanks.