Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Add columns for calculated measure in table

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:

 

MetricPriceDistance
Average$500100miles
Min$20010miles
Max$8001000miles

 

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!

1 Reply

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    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!!