Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Measure to Give Value based on Filter Selection

Hi Experts   I have the following measure which works fine... What i want to happen is if i select from management, management[level4] say ID%AB, then i still want to see the result of the measure ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    7 years ago

    Anonymous, do you mean that if you want to filter mangement, the result keeps the same?

     

    Please try below code.

     

    ID (EMEA) vAOP$ 2 = CALCULATE(
            [$NSvPY4% (NOE @ AOP Rate)], FILTER(
                    'Product','Product'[Product Franchise]="Infusion Devices"),all(Management),Management[Level4]="EMEA (Euro Mideast Africa)")

     

    Thanks and BR

    Ryan

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
7 years ago

Anonymous, do you mean that if you want to filter mangement, the result keeps the same?

 

Please try below code.

 

ID (EMEA) vAOP$ 2 = CALCULATE(
            [$NSvPY4% (NOE @ AOP Rate)], FILTER(
                    'Product','Product'[Product Franchise]="Infusion Devices"),all(Management),Management[Level4]="EMEA (Euro Mideast Africa)")

 

Thanks and BR

Ryan

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    Thanks Ryan. Spot on.