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

     

MattiaFratello's avatar
MattiaFratello
Super User
7 months ago

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's avatar
    kipi17
    New Member
    7 months ago

    Thanks , what can be a workaround here?