Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.