Calculate measurment Dynamicly based on filters

[Anonymous]

Im calculating one measure as per below:

Var = (tablename[Totaldays]-AVERAGE(tablename[Total Days]))

But report is having muliple slicer like district,region ,store and dates.

While calculating Var measure its always taking avearge of total days eventhough if we select district.

The requirement is If we select district or region or store ,the avaerge should be calculate on those levels only.

Can anyone help me on this?

[v-juanli-msft]

Hi @Anonymous

Per your requirement, you could modify "average" part as below

Measure = CALCULATE(AVERAGE(Sheet4[total days]),ALLSELECTED(Sheet4))

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

Could you try to provide a small, sample data set? Or maybe some images describing your desired output and the challenges you're seeing?

Thanks,

Ben