Forum Discussion
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 (region is being selected virtually). How can I override that (in the LHS)?
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
14 Replies
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 👍
Thanks , what can be a workaround here?
Hi kipi17
Please specify your business objective when creating this measure
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
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
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.
Thanks, but this is not my business objective; please check my reply to Elena
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
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
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
