topic Re: How to prevent a measure to update after a filter to itself on a table (visual) in DAX Commands and Tips

How to prevent a measure to update after a filter to itself on a table (visual)

Anonymous — Tue, 10 May 2022 14:47:15 GMT

Hi!

Here's a simplified version of my issue.

I have a table displayed that shows:

DATE // Value for that date // (Value - Average)/Average

I wanted to only show dates where the 3rd column is over, let's say, 15%. I added the filter to the table and it works fine.

The thing is that now the 3rd column doesn't display the original values. It now displays the values calculated with a new average, that only considers the dates that passed the 15% filter.

Is there anyway I can prevent that?

Please, be aware I cannot use ALL because I do have a date slicer so the user can determine a period, so the AVG should be calculated by the period determined by that slicer.

Thank you!

Gustavo

Re: How to prevent a measure to update after a filter to itself on a table (visual)

amitchandak — Tue, 10 May 2022 15:28:48 GMT

Anonymous , Assume you have measure value

Measure =

Var _total = calculate([Value], allselected()) //if value if of avg type

// Or Use // calculate(averageX(values('Date'[Date]), [Value]) ,allselected())

return

divide([Value] -_total, _total)

Re: How to prevent a measure to update after a filter to itself on a table (visual)

Anonymous — Tue, 10 May 2022 16:37:23 GMT

That's actually how I currently have the measures. Here's the ones I have:

Duration - Average = calculate(AVERAGE('EOD Results'[Duration PBI]), ALLSELECTED('EOD Results'))
Duration - Absolute Deviation = ABS(sum('EOD Results'[Duration PBI]) - 'Calculations'[Duration - Average])
Duration - Abs Dev / Avg = 'Calculations'[Duration - Absolute Deviation]/[Duration - Average]