Forum Discussion
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
- Varshi288
Resolver II
Hi Az38,
You are right.one of the measure was wrong. This is sorted now. Thanks.