topic Re: DAX to mask in DAX Commands and Tips

DAX to mask

Anonymous — Fri, 14 Apr 2023 04:58:05 GMT

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-public-website/

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

Re: DAX to mask

johnt75 — Fri, 14 Apr 2023 08:45:58 GMT

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.

Re: DAX to mask

Anonymous — Sat, 15 Apr 2023 03:48:48 GMT

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)