Ignore some filters / keep other in calculation

[vsevolozhskiy]

Dear all,

please support.

I have following fields: Year, Period, Factory, KPI, Value

Fields: Year, Period, Factory  are set up as filters in Application

I need to calculate Sum(Value); however KPI has to be fixed; e.g. KPI={'Revenue'}, sum has to be responsive for Year and Factory but Ignore Period

Keeping "Revenue" I understand: sum({$<[KPI]={'Revenue'}>}[Value]), but how to adjust Formula so it ignores filter for Period?

MANY-MANY THANKS in Advance

Sergey

[vsevolozhskiy]

tnx,

of course it works, it only ignores "Period" - it is much more simpler 

but it my case it has to Ignore "period" , be responsive for [FY] and [Factory] and force only one KPI [KPI]={'TotalNewOrders'} and only one Status [Status]={'Actual'}

what about PIVOT? at least in your case? I need to have Dimension "Period" o show always period 1-12 regardless of filter

[vsevolozhskiy]

can we talk via Teams? Skype?

[vsevolozhskiy]

Thanks for support, BUT

it is not the same, yours is much more simpler, of course it works.

I need to ignore "Period" in filter, respond to Year and Factory in Filter and keep KPI and Status to fixed value