Workaround for filtering aggregates

[Anonymous]

I have been trying with zero success to figure out a way to use a slicer to filter aggregate data.  I can get a slicer to filter aggregate data, but I cannot get a slicer to filter aggregate data and work with other slicers.  This seems like a fundamental thing.  For example, if I had a table with sales data for various customers, regions, salespeople,etc., I should be able to have a slicer that will filter sales over or under X, while also adjusting other filters.  It seems that power BI cannot do this.  So, I am looking for some kind of workaround.  I can set up ranges or do whatever else works to allow my customer to be able to filter in this way.  Any sugguestions?

I have attached a very simple version of the issue I am working on.  

https://1drv.ms/u/s!Am--E_G2VxhMg9U15KQ_6r4abTWq-A

https://1drv.ms/x/s!Am--E_G2VxhMg9U0-csvk20iWhIL4A

I create a column that says if Order Complete = Yes, give that a value of 1.  Then I will add all of the Complete orders to get a total.  Then I want to be able to filter on customers over or under a certain number of complete orders.  In the real world, however, I also have other filters like date.  So, let's say in my global data my highest volume customer has 100 orders.  My lowest volume customer has 10.  I can create a slicer with a slider that will go from 0-10.  However, if I filter down by date to where the customer that had 100 total orders now has 30 orders for the date range selected, the slicer is still going to go up to 100 and it's still going to filter that customer based on the 100 total orders.

In my real life situation, I am measuring time taken to perform a task and looking for problem areas.  However, there may be a situation where a the average time for a task is excessive, but there is only one record for that task/location or whatever it may be.  My customer may want to be able to filter this to only get issues that have more than one record or more than five or ten records.  They want to see issues that are occurring over a decent sample size.  I could put a filter on my report, but I want them to be able to decide.  

So, that is the somewhat long explanation, but this is pretty important for me and also something that seems like it should not be as difficult as it is.  

Thanks in advance for any suggestions.

[v-juanli-msft]

Hi @Anonymous

Your requirement can be achieved, please have a look at my test.

[Measure] show  "Complete orders"(Yes)/  "Complete orders"(all) per customer

Measure = CALCULATE(COUNT(Sheet1[Order Complete]),FILTER(ALLSELECTED(Sheet1),[Customer]=MAX([Customer])&&[Order Complete]="YES"))/CALCULATE(COUNT(Sheet1[Order Complete]),FILTER(ALLSELECTED(Sheet1),[Customer]=MAX([Customer])))

Best Regards

Maggie

[Anonymous]

Thank you, @v-juanli-msft.  I would need to filter on the measure, though, not the date.

[v-juanli-msft]

Hi @Anonymous

Which column do you want to add in the slicer?

Based on my knowledge, measure can't be added in the slicer.

I'm a little confused what result you'd like.

Best Regards

Maggie