Forum Discussion

Wresen's avatar
Wresen
Post Patron
2 years ago
Solved

Measure that only effects total sum

Hi and thx for reading this.

 

I have a simple table with 3 columns , Item , customer code and Sales (a whole number)

I put it in a Matrix table and it looks like this:

I would like to do a measure that checkes the Total Sum, it should be >=12

If i do this measure : 

Measure = if(sum('Table'[Sales] )>=12,SUM('Table'[Sales]))  , i get this resualt:



What i want is the measure to only do >=12 on Total level , not on customer code. (so i want to se the values that builds up to 13 in total for B2 and the values that builds up to the sum 16 in total for C1
 
 
/Thanks 
 

 

Need Help

6 Replies

    • Wresen's avatar
      Wresen
      Post Patron
      2 years ago

      Hi Ahmedx 

      Thanks so much for the suggestion. 
      My main thing here is to filter away the customer code (since in the main data there is alot of them)
      So i dont want to see in this case A1 at all, but all the values that build up B1 and C1 as you have .
      /Thx

      • Ahmedx's avatar
        Ahmedx
        Super User
        2 years ago

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