Forum Discussion

mtp03's avatar
mtp03
Frequent Visitor
4 years ago
Solved

Show N/A on Card visual when slicer is selected

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 vis...
Need Help
  • pbi-novice's avatar
    pbi-novice
    4 years ago

    Use 

    Measure = IF(
    ISFILTERED(PersonColumn),
    BLANK(),
    SUM(CompletionColumn)
    )
mtp03's avatar
mtp03
Frequent Visitor
4 years ago

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's avatar
pbi-novice
Icon for Helper I rankHelper I
4 years ago

Use 

Measure = IF(
ISFILTERED(PersonColumn),
BLANK(),
SUM(CompletionColumn)
)