Forum Discussion

AaronGlenn10's avatar
AaronGlenn10
Helper III
4 years ago
Solved

Hiding data or values based on selection

I have a dashboard containing restaurants sales across the State of Texas -- when a user selects a City then the top performing location for that City will display [see below[ - however, when a user ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi AaronGlenn10 

     

    You could use HASONEVALUE function (DAX) in an IF condition in your measure. Below is an example.

    Measure 2 = IF(HASONEVALUE('Table (4)'[Item]),BLANK(),[Measure])

     

    In your scenario, you could try

    IF(HASONEVALUE('Table (4)'[Location Name]),BLANK(),[TopLocationSales])

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi AaronGlenn10 

 

You could use HASONEVALUE function (DAX) in an IF condition in your measure. Below is an example.

Measure 2 = IF(HASONEVALUE('Table (4)'[Item]),BLANK(),[Measure])

 

In your scenario, you could try

IF(HASONEVALUE('Table (4)'[Location Name]),BLANK(),[TopLocationSales])

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.