Data segmentation (visual object) is not working in the matrix because of ALLSELECTEC

[DLJ]

Hi all,

I would be very grateful if you could solve this problem.

I am trying to filter a matrix with a data segmentation visual object in the dashboard. But it does not work because I have a column in which I am using the filter ALLSELECTED (inside a CALCULATE formula).

So how can I set up an order of priority for external slicers, in such a way my Segmentation Data Slicer is going to work?

By the way: all tables are correctly connected.

Thank you very much

[v-frfei-msft]

Hi @DLJ ,

How about changing ALLSELECTED(table[Column]) to ALLSELECTED(table) to have a check? 

If it doesn't meet your requirement,  kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[DLJ]

Thanks to all. Very appreciated.

I will be studying and trying all your tips during theses days at work. I will let you know my progress.

Although information is confidential, I will create an example with random data to share with you if all these tips do not work.

Thanks again

@v-frfei-msft @amitchandak @Greg_Deckler  

[Greg_Deckler]

Sure @DLJ just let us know!

[amitchandak]

Refer this and let us know more information

https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept...

Appreciate your Kudos.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490