Only display results when filter is selected

Hi totamum ,

try this:

Show Above/Below Average =
IF (
ISFILTERED ( Users[User] ), -- Checks if a user is selected
[Above Below Average Measure], -- Displays your existing measure when a user is selected
BLANK() -- Returns blank when no user is selected
)

Please mark this as solution if it helps you. Appreciate Kudos.

Solution 1: DAX for Visibility Management

To limit the card being shown, you will need to create a measure that returns a value only when a user is selected, otherwise a blank value is returned.

Step 1: To Create a Measure

DAX

Edit Copy
AboveBelowAverage =

VAR SelectedUser = SELECTEDVALUE(‘Users’[User])

VAR UserPageViews = SUM(‘PageViews’[Views])

VAR AvgPageViews = AVERAGE(‘PageViews’[Views])

RETURN

IF(

ISBLANK(SelectedUser),

BLANK(), – Hide when no user is selected

IF(UserPageViews > AvgPageViews, “Above Average”, “Below Average”)

)

Step 2: Make This Card Measure Active

Using Power Bi Card visual’s field function, take out the current field and replace it with this measure.

Above/Below Average card, will usually not display when no user is selected as Power BI card visuals automatically hide blank values.

Solution 2: Apply a Visual Level Filter
Another option is applying a visual level filter to the card.

Click the Above/Below Average card.

Go to Filters pane and on filter type select ‘Users’[User] field.

Filter to is not blank.

This ensures that the card only shows up when a user is selected.

Hi totamum ,
If you need to ensure that exactly one user is selected, you can use HASONEVALUE function:

AboveBelowAvg =
IF(
    HASONEVALUE(Users[UserID]),  // Check if exactly one user is selected
    [Your measure used to calculate bellow and above],
    BLANK()
)

Or you can check if the UserID column is being filtered ( with one or multiple user's):

AboveBelowAvg =
IF(
    ISFILTERED(Users[UserID]),  // Check if there's any filter on the UserID column
    [Your measure used to calculate bellow and above],
    BLANK()   // Return blank when no filter is applied (i.e. no user is selected)
)