topic Re: How to return a value without aggregating the sum of each rows by using new measure or dax? in DAX Commands and Tips

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

ironboy0418 — Wed, 19 Apr 2023 11:03:08 GMT

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:

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

barritown — Wed, 19 Apr 2023 12:08:48 GMT

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

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

FreemanZ — Wed, 19 Apr 2023 12:12:51 GMT

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]))
)