Keep Unique Rows Feature Like In The Power Pivot Data Model

Currently there is no way to prevent grouping by dimensions of the same name. For example, when mapping population by county, every Washington county is summarized into one value and that same value is placed in each state that has a Washington county.

Similarly, when Bill Adams, Joe Adams and Susan Adams are put on a chart or table using the LastName field, all Adams are combined into one value.

The Power Pivot data model can keep each Washington or Adams separate using the Keep Unique Rows feature.

This feature needs to be available in Power BI Desktop.