How to return a value without aggregating the sum of each rows by using new measure or dax?

[ironboy0418]

I have a sample table in Power BI that has repeating value for price. The objective is to return the prices for each category without summing-up all the values in row price.

Sample table:

Desired output:

[FreemanZ · Accepted solution]

hi @ironboy0418 

there are many ways:

you can just plot a table visual with category and price columns. Choose min, max or average for price column.

or
plot a table visual with category columns and a measure like:
measure = MIN(TableName[Price])

or
create a calculated table like:
Table =
ADDCOLUMNS(
VALUES(TableName[Category]),
"Price",
CALCULATE(MIN(TableName[Price]))
)

[barritown]

Hi,

Why don't you just a table visual, add Category & Price to its Values field and then choose Average or Median in the options for aggregation?

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian