Visual Level filter Context not getting ignored in Total Turnover Measure.

[Anonymous]

I have a measure named Total Turnover which calculates the sum of Turnover as per the filters applied.

Total Turnover =

CALCULATE (

SUM ('GCF vw_FactGeographycategoryfocus'[TurnoverEuro]),

ALLSELECTED( 'GCF vw_FactGeographycategoryfocus')

)

When I am using this Total Turnover Measure in a table Visual the Total Turnover is getting calculated perfectly as per the filters that has been applied ignoring the row context in the table.

But when I am adding any Visual Level Filters to the Table visual the value of Total Turnover is getting changed , but i dont want the Total Turnover to change as per the Visual Level filters applied.

Can anyone please help me out in this scenario. 

Urgent Help needed.

[v-chenwuz-msft]

Hi @Anonymous ,

You can keep the filter you want by ALLEXCEPT() or remove filters by REMOVERFILTER() which you do not want to keep. Or All() to fix the result.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TheoC]

Hi @Anonymous 

Take a look at this link and hopefully you'll be able to identify the cause: https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/

All the best.

Theo 🙂