Measure based on data from another measure with condition

Question

HiCould you please help me to find a solution?&nbsp;&nbsp;The task is to calculate the deviations from the previous year by positions, provided that there is a zero value in the previous period. That is, the task is to counting in case if in last period this position value is zero. Data for the past period are calculated using the measure:Previous Year = CALCULATE(SUM('Table1'[summa]),SAMEPERIODLASTYEAR('Calendar'[Date]))Next I'm trying to use this formula:vs Previous Year = IF(CALCULATE('Table1'[Previous Year])=0,(SUM('Table1'[summa])-'Table1'[Previous Year]),0)And I see deviation by position, but I don't see totals and subtotals value.&nbsp;&nbsp;

tamerj1 · Answer

Hi&nbsp;Anonymous&nbsp;What is the purpose of the IF statement?

anonymous · Answer

Hi&nbsp;if&nbsp; value of position in previous year = 0&nbsp; in this case need calculate difference between previous year and actual year. Indeed this is short version of formula, for checking work it or not

tamerj1 · Answer

Anonymous&nbsp;But if the previous year is zero then the difference is just the current year! Also would you please clarify what are you slicing by in your report. Thank you

anonymous · Answer

Indeed I need calculate mix factor,&nbsp;I've got a lot of items, some of them were produced in this year, but weren't in previous? and some of them weren' produce this year, but were in previous period. And I need to calculate (Value per position this year - Value per position previos year) in case if or Value per position this year =0 or&nbsp;Value per position previous year =0. This is full task&nbsp;&nbsp;

v-easonf-msft · Answer

Hi，&nbsp;Anonymous&nbsp;
Can you share a sample file for further research?
Best Regards,Community Support Team _ Eason

Forum Discussion

Measure based on data from another measure with condition

5 Replies

Related content

Cumulative Difference from Another measure

Conditional Measure

Conditional measure of another measure.

Max measure can't be used as condition in another measure?

Filter measure by another measure