Forum Discussion

AKor's avatar
AKor
New Member
8 years ago
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...
  • AKor's avatar
    AKor
    8 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

AKor,


I make a test using my sample data, everything works well, you can review the following screenshots.


Could you please share dummy data of your table? I will test it in my environment.


Regards,
Lydia

AKor's avatar
AKor
New Member
8 years ago

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!