Forum Discussion

BBIUser's avatar
BBIUser
Helper IV
2 years ago
Solved

Dynamic text based on masked data in the table

Hello,   I need to create a dynamic text based on few masked data which is already in the table. Sample Data: I have created a measure to not to show the data on the bar charts based on the...
Need Help
Show and Tell
Tips and Tricks
  • amustafa's avatar
    amustafa
    2 years ago

    Update the measure as following...

    DisplayMessage = 
VAR EmployeeCountMoreThanOne = CALCULATE(COUNTROWS('Sheet1'), 'Sheet1'[Employee Count] > 1)
VAR IsAnyRowMasked = CALCULATE(MAXX('Sheet1', IF('Sheet1'[Masked] = "Yes", 1, 0)), ALLSELECTED('Sheet1')) = 1
RETURN
    IF(EmployeeCountMoreThanOne > 0 && NOT IsAnyRowMasked, "Data Masked", BLANK())
BBIUser's avatar
BBIUser
Helper IV
2 years ago

amustafa Thank you! It works.

Ashish_Mathur DAX that you gave me doesn't fit the solution. amustafa solution worked correctly. Appreciate your reply!