Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Good morning,
I want to create a measure in a matrix report table, but I don't know how to name the differents columns. In these case, I want to divide the unr T column into the Avg FC T column but onces I enter the formula it appears a mistake that says that the name entered is not valid. How can I do it?
In advice, thank you for everything.
Best regards,
@pinolss , Out of these which are measures and which are columns with aggregation. Meausre will only table measures or columns with aggregation
example
Measure = Sum(Table[Col1])
measure = [Meausre] / Avg((Table[Col2])
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
I want to divide the unr T column into de Avg FC T, but as you see onces I have values in one of them I don't have in the other, so the only thing I can do is to divide the sum in the result matrix. How can I do i t?
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 6 | |
| 4 | |
| 3 | |
| 3 | |
| 3 |