Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Total in Card visual

Hi!

 

How do I set a filter on card visual?

 

The total should be 3.353 but the cards shows 48.354 because it shows everything and not only the stock less then 1.

 

I get that the visual cannot be filterd in such way because it is aggregated, but how do I solve this?

 

Help would be much appreciated! 

 

 

 

Need Help

4 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Please create a measure like below:

    Measure = CALCULATE(SUM(TABLE[XXX]),FILTER(ALLSELECTED(TABLE),TABLE[Stock End]<1))

     

     

    Best Regards,
    Liang
    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
      5 years ago

      Hi!

       

      My stock end measure is not a column from table. It is also a measure, do you have a solution for that to?

      • mussaenda's avatar
        mussaenda
        Community Champion
        5 years ago

        Hi Anonymous ,

         

        did you manage to solve this?

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    what is the measure and what is the filter context on the table?