Forum Discussion

kipi17's avatar
kipi17
New Member
7 months ago
Solved

DAX issue ISBLANK

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 (r...
Need Help
  • v-dineshya's avatar
    v-dineshya
    7 months ago

    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

     

MasonMA's avatar
MasonMA
Super User
7 months ago

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's avatar
danextian
Super User
7 months ago

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.”