I have some client-facing analytics that uses row level security to select only relevant data for each client.
However, because clients can have more than one property (a string dimension), the filter that loads for this ends up populating as blank, so when a user logs in they see no data until they find a drop down and pick their property.
If I were using a dynamic parameter that selected the relevant properties at the point of loading, what will the user see at the point the dashboards loads? The first relevant value loaded to the parameter, or the last one I had selected?
That won't work - you can't use table calculations for a parameter default value, because they depend on the data in the worksheet, and a parameter has to be independent.
You can use an LOD function, however, which can be as simple as the example in the documentation, or more complicated. For the first option in a dimension you can try something like {FIXED: MIN([Dimension Name])} and it should work with RLS.
Dan Chissick
Senior BI Consultant | Tableau Forums Ambassador
