DAX to mask

[Anonymous]

Hi everyone,

I am using the following DAX to mask earners < 5.

Count Masked =

VAR GetCount =

    COUNTROWS(CCMP)

RETURN

    IF ( AND ( GetCount < 5, GetCount > 0), "*", GetCount)

This code comes courtesy of this website - https://wisedatadecisions.com/2021/06/06/data-masking-with-rls-and-dax-even-when-embedding-on-a-publ...

My goal is to adapt the DAX to my use case - maintain the totals but mask any values less than 5. 

However, every value has an asterisk. I only want an asterisk to mask a value of less than 5. Please see attached file. 

CCMP_Mask_TEST.pbix

Any nudge is greatly appreciated. This is fake data but the problem is real. 

Luis

[johnt75 · Accepted solution]

The measure is fine, but when you go down to the granularity of campus and certification there is only 1 row in the table for each combination, so countrows returns 1 and everything gets masked. To see a mix of masked and non-masked values you would need to go to a higher granularity.

[Anonymous]

Hi @johnt75 ,

Thank you! I should have realized that this is summarized data. 

Your nudge helped me figure out the DAX.

Count Masked =

VAR GetCount =

    SUM(CCMP[Earners])

RETURN

    IF ( AND ( GetCount < 5, GetCount > 0), "*", GetCount)