Measure that only effects total sum

[Wresen]

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

https://drive.google.com/file/d/1KJdsPr81VbITAovX1aSjU6flkz8vxe9q/view?usp=sharing

/Thanks 

[Ahmedx]

pls try this

[Wresen]

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]

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

[Wresen]

Sorry if i was not clear enough

This is the resualt i am looking for.

/thanks

[Ahmedx · Accepted solution]

pls try htis

[Wresen]

Thanks so much @Ahmedx  for you help 🙂