Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Ignore Slicer in Measure

Hi Guys,

Hopefully somebody has an idea to get my issue resolved. I created a visual which shows a bar graph for two measures and is controlled by 7 slicers. For one of the two measures only the slicer "Zeitfenster Abschlussrate (Monate)" should be ignored and set to the value 1 instead. Using Interactions isn't possible as the second measure used for my visual depends on this slicer. I'm using this measure, but this doesn't work as expected:

 

Opps_won_Rev_Abschlussrate =
CALCULATE(SUM(Opps_Sharepoint[Gesamtpreis]);
FILTER(ALL(Opps_Sharepoint[Zeitfenster Abschlussrate (Monate)]);
Opps_Sharepoint[Zeitfenster Abschlussrate (Monate)]=1);
Filter(ALL(Opps_Sharepoint[Phase]);
Opps_Sharepoint[Phase]="6a. Geschlossen (unterschrieben)"))

 

Many thanks for any idea.

Need Help

3 Replies

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi Anonymous ,

    If possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Zoe Zhi,

       

      Thank you for your feedback. Meanwhile a found a workaround in splitting the grouped bar chart into two separate charts. For one I used interactions to prevent any influence from the slicer I don't want to have. Maybe a quick and dirty solutions, but it fits my requirements for the moment.

       

      Best Regards,

      Caesareus

      • dax's avatar
        dax
        Community Support
        6 years ago

        Hi Anonymous ,

        Thank you for your sharing!

        Best Regards,
        Zoe Zhi

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.