Forum Discussion
Suppression within matrix table challenges
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/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
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