Forum Discussion
Solved
filters
Hello, I was wondering if anybody can help me with a formula. I have a set of salespeople who are responsible for different products. I created a formula which overwrites existing filter on salesper...
Hi Lydia,
In your example, what I need as a result is to have $8,341,224,364.83 but only showing one Class Name - Economy. I think I found the solution to it by creating the additional measure which I use as a filter: IF(sum(Sales[SalesAmount])>0,1,0) and then I filter on 1. In this case I use ALL in the original measure instead of ALLSELECTED, and it seems to work.
Thank you for your help!
