Suppression within matrix table challenges

[y3wan]

I have created a Matrix table with Number and Percentage Conversation + Suppression.

However, I realized my audience can calculate the suppressed value by taking other numbers under the same column and divided by it's percentage value. 

Therefore I am attempting to suppress the entire column (under Percent) if there are any "<10" values.

Anyone may share their experience or have ideas to achieve such end result would be much appreciated.

Should I create some sort of group to target those values under those dynamic columns?

[y3wan]

In the table above, the value for Shampoo in store B is suprressed as "<10"
When I convert my value to percentage, audience can calculate the suprressed value by using other Shampoo values and divided by it's percentage value.

As a result, I also need to suppress the percentage values for all other stores under shampoo.

And here come's the tricky part; This is a matrix table which the values is based on a measure calculation.

Anyway I was able to achieve a workaround by creating a new column in my source table that would indicate all the percentage values that would need addition suppression.

Thank you

[v-yanjiang-msft]

Hi @y3wan ,

What do you mean "suppress the entire column", could you please explain more about your expected result?

Best Regards,
Community Support Team _ kalyj

[amitchandak · Accepted solution]

@y3wan , Not very clear. Are you looking for Segmentation of measure ?

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k