The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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?
User | Count |
---|---|
14 | |
12 | |
8 | |
6 | |
5 |
User | Count |
---|---|
29 | |
19 | |
13 | |
8 | |
5 |