IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE "*" END Refer: https://kb.tableau.com/articles/howto/when-to-use-the-attribute-attr-function

Select California State from the Map

Tableau automatically associates discrete fields with categorical palettes Refer: https://help.tableau.com/current/pro/desktop/en-us/visual_best_practices.htm

Find out the distinct orders for each customer
Graphical user interface, text, application Description automatically generated

Move this field from Measure to Dimension.
Drop this field to the Columns Shelf and drop customer ID to Rows, aggregate the Customer ID using CountD, and drop this field to Label as well. Your view will look like this:
Chart Description automatically generated

29 distinct customers have made 6 orders.

It is recommended to create multiple table extracts when row-level security needs to be enforced.
Refer:
https://www.tableau.com/about/blog/2018/10/you-can-now-choose-multiple-table-storage-extracts-94776