Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
AaronGlenn10
Helper III
Helper III

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 selects a Individual Location/Restaurant then it returns the name of that restaurant and a (Blank) for the value [see below].  Is there a way for the entire section to be blank when an invidual location is selected instead of a City [will all locations selected under that City]?

 

Here is the measure I'm using to return top performing restaurant in the Selected City ->

TopLocationSales = calculate([TABC Sales (CY)],KEEPFILTERS((topn(1, all (TABC[Location Name/City/Number]), [TABC Sales (CY)]))))

 

AaronGlenn10_0-1645359052542.png

 

AaronGlenn10_1-1645359265066.pngAaronGlenn10_2-1645359317663.png

 

 

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

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])

vjingzhang_0-1645601586771.png

 

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.

View solution in original post

1 REPLY 1
v-jingzhang
Community Support
Community Support

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])

vjingzhang_0-1645601586771.png

 

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.