SQL Server Analysis Services Multidimensional Model had a functionality to exclude attribute values by default, even though they were not part of any selection. The result would be that records with this value or records with a relationship to this value would not be included in a selection, unless the attribute value would be selected explicitly.
For example you'd likely report about orders in most cases excluding a provisional order status. My aim is to prevent users from accidentally reporting results including such provisional orders.
My knowledge of Multidimensional is dated at least six years, I have no recollection of this existing in Tabular Model nor did my Google result give me anything useful. However, I would like to think this should be possible one way or another, even with a workaround.
Do you know how to accomplish this? If any relevant information is missing, please let me know.
For example you'd likely report about orders in most cases excluding a provisional order status.
There's no modeling feature for this, except perhaps row-level security where you could prevent most users from seeing provisional orders.
Normally you would handle this at the reporting layer in Power BI by setting a report-level filter on order status.