How do i use ALLEXCEPT but keep the pagefilters?

[StanTheMan]

Hi all,

I'm working on a visual that shows the number of active orders and how many customers/clients come with these orders based on the assigned filter dates. We check the orders activity with a start and end date. As far as i'm aware you can't count values on the x and y axis at the same time so i used the following dax lines to create the visual shown below:

tmp_OrdersPerClient =

CALCULATE(

DISTINCTCOUNT(dim_order[ordernumber]);

ALLEXCEPT(dim_order;dim_order[clientnumber])

)

The problem with this dax formula is that my page filters/slicers don't apply on the visual, does anyone know how to achieve this?

I'm curious and looking forward to your sollutions!

Thanks in advance!
Stan

[v-lili6-msft]

hi, @StanTheMan 

Sample data would help tremendously.

 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

And if you had a issue like this:

https://community.powerbi.com/t5/Desktop/Make-measure-ignore-specific-filter/td-p/336870

if not please share a simple sample pbix file and your expected output.

Best Regards,

Lin

[StanTheMan · Accepted solution]

Hi,

The problem is not solved yet, but i did found a work around for my issue. Here's what i figured out on this specific problem:
The solution i came up with works by using a measure and some variables, but i can't drop a measure on a visual x-axis wich is needed to get the right visual. So i tried using a calculated column, but due to it being a static field, this won't work either. 

In the end we created a new table with ssms, it's not perfect but it works for now.