Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

Creating a new measure based on an earlier one

I'm still struggling with applying confidentiality to our data.


At the moment I have changed all values in a matrix table to '< 5' if the data is between 1 to 4 (I want to keep true zeroes). I want to be able to change the next lowest number in a row or a column to 'np' (i.e. not provided). This will add a secondary layer of confidentiality to the data. I've tried using countrows and ranking, but I'm not getting the results I require. Here is the first formula I use to get the '< 5' value:


Patient Counts =
IF (
CALCULATE ( SUM ( Patient[counter] ) ) < 5 && SUM ( Patient[counter] ) > 0,
"< 5",
CALCULATE ( SUM ( Patient[counter] ) )


I have posted a similar question to this. But rather than just remove the totals and sub-totals I really want to go down the secondary suppression route. Thanks for your time.

Super User
Super User

Agree with @MFelix, need sample data and expected results. Please see this post regarding How to Get Your Question Answered Quickly:

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Super User
Super User

Hi @Axit,


Without any further data is difficult to answer you but believe that what you need is something similar to what I have made in the post below.


Don't Know how you want to present your data but the import part is the FILTER part of the summarize table.





Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

Hi @MFelix and @Greg_Deckler. I should have provided more data as an example earlier. So these are the types of results I'm trying to reproduce:


Confidential table.PNG


In this table all the values less than 5 (i.e. between 1 and 4) are shown as "< 5". The secondary suppression is applied to typcially the next lowest value as "np", so that the less than 5 number cannot be calculated.


So far I can get the "< 5" working fine, but I really need to be able to do the "np" too so that I can keep both the row and column totals.


Thanks again for looking at this.

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!