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

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

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