Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter and sclicer causing visualization discrepency

Hi

I am a beginner in Power BI and I would like to know the feasibility/solution for my Queries.

 

For a given data table "Prototype Modeling_freight" I have a measure as:

 

volume = SUMX('Prototype Modeling_Freight', 'Prototype Modeling_Freight'[Sold Cases])

 

this converted to percentage for each type of equipment as:

 

Volume distribution = DIVIDE([volume],CALCULATE([volume],ALL('Prototype Modeling_Freight'))),0)

 


And visualized as clustered column chart

Now there are specifically two things I want this chart to do:

when I filter out through a date sclicer my chart must compare the data only within those sclicers, (note these sclicers can be other than dates)

Eg:

If you consider the Y axis in above picture, I want them to present 100%, or 'what was 25N's contribution in June month?'.

 

 

 

Thank you

 

 

  • Hi Anonymous 

     

    Try this instead

    Volume distribution = DIVIDE([volume],CALCULATE([volume],ALLSELECTED())),0)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn


     

4 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion

    Hi Anonymous 

     

    Try this instead

    Volume distribution = DIVIDE([volume],CALCULATE([volume],ALLSELECTED())),0)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn


     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you Mariusz, it worked. I would like to understand how is this happening?

       

      • Mariusz's avatar
        Mariusz
        Community Champion

        Hi Anonymous 

         

        Sure, ALL() removes all filters from the filter context where ALLSELECTED() only the current one ie current visuals filters preserving all other filters coming from outside.

        For more info please refer.

        https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/

         

         

        Best Regards,
        Mariusz

        If this post helps, then please consider Accepting it as the solution.

        Please feel free to connect with me.
        LinkedIn