Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Workaround for filtering aggregates

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...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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