Calculate measure value based on range of another measure.

Iwin — Sat, 19 Feb 2022 05:09:08 GMT

Hi,

I have the below scenario where:

I want to calculate value of sales value derived based on range of MPE Volume measure value:

eg : if range of MPE Volume value is -5 to 5

I want to calculate value of Sales value derived only for those MPE Volume values between -5 to 5 .

I tried using set analysis as below but it is giving error:

sum({<((sum([1_Forecast Quantity ZU Unit])-sum([Sales Qty ZU CHK]))*100)/sum([Sales Qty ZU CHK])={">=-15<=20"}>}
aggr($(vSalesValueDerived),[Country key TEXT],Material,[Forecast Accuracy Period],[Profit Center]$(vRadio_Button))))

Also tried calculating it using if condition as below:

if(MPE_Volume>-15 and MPE_volume <20,

sum(Sales_derived)) but it is always giving the total value instead of value between the range.

Thanks.

@sunny_talwar

topic Calculate measure value based on range of another measure. in App Development

Calculate measure value based on range of another measure.