Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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])
Solved! Go to Solution.
Hi Az38,
You are right.one of the measure was wrong. This is sorted now. Thanks.
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
Hi Az38,
You are right.one of the measure was wrong. This is sorted now. Thanks.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |