Forum Discussion

smasl94's avatar
smasl94
Frequent Visitor
1 year ago
Solved

Implement data masking within matrix visual using DAX expressions

Hi!   I am currently building a report and I would like to mask all leaf (i.e., age_group) values for a specific combination of association_id and gender if any of the leaf values is between 1 and ...
  • smasl94's avatar
    smasl94
    1 year ago

    Hi, all!

     

    Thanks to all of you for providing solutions!

     

    It turned out that there were some rows in the Azure SQL database table that contained null values for the age_group field, which messed up with the calculations. Therefore, I used bhanu_gautam's suggestion and then added the condition `NOT ISBLANK('gold fact_member_count_monthly_sylwester'[age_group])` within the FILTER function to exclude such rows from being accounted in the calculations, then it worked like a charm.

    Once again, thank you for helping me out with this one!

smasl94's avatar
smasl94
Frequent Visitor
1 year ago

Hi, all!

 

Thanks to all of you for providing solutions!

 

It turned out that there were some rows in the Azure SQL database table that contained null values for the age_group field, which messed up with the calculations. Therefore, I used bhanu_gautam's suggestion and then added the condition `NOT ISBLANK('gold fact_member_count_monthly_sylwester'[age_group])` within the FILTER function to exclude such rows from being accounted in the calculations, then it worked like a charm.

Once again, thank you for helping me out with this one!