Show N/A on Card visual when slicer is selected

[mtp03]

My report shows a summary of all staff performance to target. The Completion Rate is the total performance (sum of all completions) to the target (there are no individually based targets). I have visuals that break this down by the person, but the Completion Rate is an overall figure. Is there a way to make it so if anything is selected in the people slicer, the Completion Rate card visual shows "N/A?" Currently, it takes the person's completed and divides by the overall target, which ends up showing a very low, inaccurate percentage Completion Rate. This number is throwing people off so I put a note there, but was wondering if I can just make it show nothing or "N/A" if any person is selected in the slicer.

[mtp03]

Okay this almost exactly what I need, but if they select more than 1 person, is there a way to do this same thing?

[pbi-novice · Accepted solution]

Use 

Measure = IF(

ISFILTERED(PersonColumn),

BLANK(),

SUM(CompletionColumn)

)

[pbi-novice]

If the people column has only one filter applied at anytime(selecting specific person(s)), I would use the following:

Measure = IF(

HASONEFILTER(PersonColumn),

BLANK(),

SUM(CompletionColumn)

)

And use that measure in place of the "CompletionColumn". You can also replace Blank() with any string such as "N/A".