Add columns for calculated measure in table

[Anonymous]

Hello,

In my facts table, I have a column for price and distance for every transaction. I want to put a table in my report in which I can see the average, min, max, etc, which should look as follows:

Metric	Price	Distance
Average	$500	100miles
Min	$200	10miles
Max	$800	1000miles

I currently have the average, min, and max as measures, but don't know how a table as shown above. I can only get two seperate tables for Price and Distance, but I want to have it in one table that responds to the filters on the page.

Thanks!

[VahidDM]

Hi @Anonymous 

Try this code to add a new table:

Table =
UNION (
    ROW (
        "Metric", "Average",
        "Price", AVERAGE ( [price] ),
        "Distance", AVERAGE ( [Distance] )
    ),
    ROW (
        "Metric", "Min",
        "Price", MIN ( [price] ),
        "Distance", MIN ( [Distance] )
    ),
    ROW (
        "Metric", "Max",
        "Price", MAX ( [price] ),
        "Distance", MAX ( [Distance] )
    )
)

[price] = Price column 

[Distance] = Distance column

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!