DAX issue ISBLANK

[kipi17]

Hello Team,

Why Show_Row is giving different outputs there?

It should be false in both the outputs since there is no selection of any region

This is probably because of the row context (region is being selected virtually). How can I override that (in the LHS)?

[v-dineshya · Accepted solution]

Hi @kipi17 ,

Thank you for reaching out to the Microsoft Community Forum.

What you are seeing is correct Power BI behavior, and it is a hard limitation, not a DAX bug. DAX CANNOT “remember” a previous slicer selection after it is deselected. Measures are stateless. Once the slicer is cleared, the information is gone. That’s why your table shows all regions again. By using slicers, you can't achieve the desired result. But by using the Bookmarks + Buttons, you can achieve the desired result.

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

[v-dineshya]

Hi @kipi17 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[v-dineshya]

Hi @kipi17 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[MasonMA]

Hi,

SELECTEDVALUE() only returns a value when exactly one distinct value exists in the current filter context.

In your matrix, at Total/higher levels or when multiple regions exist in scope, SELECTEDVALUE() returns BLANK, but you can force it to give True like below.

[kipi17]

Thanks, but this is not my business objective; please check my reply to Elena

[Elena_Kalina]

Hi @kipi17 

Please specify your business objective when creating this measure

[kipi17]

hi @Elena_Kalina ,

This is to control Power BI action; once I deselect a bar, the table should be fixed to a region, say West, 

Regards,

KIPI

[Elena_Kalina]

Hi @kipi17 

I'm a little confused by your answer. You wrote: 'once I deselect a bar, the table should be fixed to a region, say West.' That means you selected, for example, the West bar, and when you removed that selection, in the bar chart all values should be highlighted again, but in the table the value you selected should remain, is that right?

Best regards,

EK

[kipi17]

Desired Behavior: When a user selects West/East/Central, the report should display only the corresponding region’s sales, which is the default behavior of Power BI filters.

However, if the user deselects the region, it should retain the previously selected region instead of reverting to “Show All.”

For example:

• If I click West, it should filter to the West region.
• If I click West again, it should remain on West, rather than showing all regions (which is Power BI’s default behavior).

The same logic should apply to East and Central.

[MasonMA]

I dont think this would be natively possible.

When you click to deselect the region, Power BI visuals clear the filters. This behavior would have been hard‑coded and cannot be modified in visual interactions. If you look for workarounds, you may test with disconnected Region table with no physical relationship so that you can use DAX to drive your measures based on selection. 

[danextian]

Yes, not currently possible. Power BI doesn’t retain previous slicer selections. It only knows what’s currently selected, so if nothing is selected or previous selections have been deselected, it treats it as “select all.”

[kipi17]

Yes, but I am not sure if we can do this even with disconnected tables

[MattiaFratello]

Hi @kipi17 , 

The Show_Row measure produces different outputs because, in the matrix row contexts (e.g., for East and West regions), it detects a single region via row context from the Region column, evaluating to TRUE, while the true Grand Total uses only the overall filter context (no slicer selection), making it FALSE.​​

Row context from the visual's Region hierarchy implicitly "selects" one region per row, overriding pure filter context checks.

If this has helped you please feel free to mark it as a solution and to give kudos 👍

[kipi17]

Thanks , what can be a workaround here?