Measure showing wrong results afer adding 2020 data.

[Varshi288]

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])

 

[az38]

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 · Accepted solution]

Hi Az38,

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