Retrieve Single Unique Value from Expanded Rows

[naridox]

I expanded rows in table to allow CSVs their own iterative rows. Unfortunately, one of the unique column values is now duplicated. All I need is that single value in a table visualization, but instead it tries summing it, or summing all the values.

While I understand the principle of row context, I still struggle how to actually work with it. I need to gain the unique value from the expanded rows, either to merely to display or to calculate with. Also, expanded rows often trip me up because I don't know how to handle them very well.

My attempt:

Quote Ct = CALCULATE( MAXX( 'Distinct Titles' , 'Distinct Titles'[Quote Count] ) / DISTINCTCOUNT( 'Distinct Titles'[Distinct Title] ) )

QUERY::

FRUIT   QTY   Type

Apple   15       01

Apple   07       01

Apple   09       01

Grape   10       03

Grape   05       03

VISUALIZATION: (Not wanted)

FRUIT   QTY   Type

Apple    31      03 (Sums)

Grape    15      06

VISUALIZATION: (Intended)

FRUIT   QTY   Type

Apple    31      01

Grape    15      03

I appreciate any help!

[naridox · Accepted solution]

I realized I asked the question the wrong way and found a workaround. I can't delete this thread, which is why I'm marking this as "the answer" so the thread will close. Thanks for your time.

[mussaenda]

Hi @naridox ,

if the TYPE column does not need to be aggregated, change the data type to text so it won't add up.

[Ashish_Mathur]

Hi,

To your visual, drag Fruit and write these measures:

Quantity = SUM(Data[Qty])

Types = MIN(Data[Type])

My assumption is that Type is a numeric column.

[Nathaniel_C]

@naridox ,

Type is not a number to be added or subtracted, correct? Mke Type a Text column.  I do that with all my ids etc.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel