How to mask values in a pie chart based on powerquery measure context

[Anonymous]

Hi all,

i'm managin a report about employeee assesment so data under privacy restriction.

one of the rule is that the report should mask values in case of usere select a group of less than 5 employee.

the basic chart is a pie showing how many competencies managers marked as ok/nok (value 1 or 0 in ManagerOk column)

 so i created a powerquery measure

5+SelectedEmployee = IF(DISTINCTCOUNT(HRAssesment[Employee ID])>=5,"ok","nok")

and a new column with maskedvalue at 100


i'm trying now to use switch function to create a MaskedMAnager

MaskedManagerOK =

SWITCH([5+SelectedEmployee],

                    "ok",'HRAssesment'[ManagerOk],

                    "nok",'HRAssesment'[MaskedValue]

                    )

and assign as legend in a pie chart

but the pie chart read the power query always as "nok" i guess because it read the value of "5+SelectedEmployee" in the table context for each row and in the selection context of pie chart.

title of this chart represent the value of the power query measure 5+SelectedEmployee. 

if ok it should give ok/nok chart

any suggestion?

[Anonymous · Accepted solution]

Hi, @Anonymous 

Thank you very much for @lbendlin suggestion, based on my testing I think it's something wrong with the Measure you wrote, it doesn't return ok/nok you can refer to the following measure.

New 5+SelectedEmployee = 
VAR _result =
    CALCULATE (
        COUNTROWS ( HRAssesment ),
        FILTER ( HRAssesment, DISTINCTCOUNT ( HRAssesment[Employee ID] ) )
    )
RETURN
    IF ( _result >= 8, "ok", "nok" )

Best Regards,
Yang
Community Support Team

If this does not work, could you please share some sample data without sensitive information and expected output.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[lbendlin]

You cannot mask data after the fact.  You need to base your entire solution on pre-masked data.