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.
How to give the column of data type text in a measure calculation without using any aggregate functions, beacuse in showing the final total sum in matrix visual it is showing wrong calculation when taking aggregate functions?
SITE ENGINEERS = IF(MAX('Mapped data'[PRODUCTS]) = "DL",COUNT('Mapped data'[INSTALLED_SNO])/30,IF(MAX(('Mapped data'[PRODUCTS])) = "RTU",COUNT('Mapped data'[INSTALED_SNO])/60,IF(MAX(('Mapped data'[PRODUCTS])) = "PTHMU",COUNT('Mapped data'[INSTALLED_SNO])/60 )))
Hi @AnilKumar,
As you create a measure instead of calculated column, it's necessary to use aggregate functions when a measure refers to a column. Otherwise, it can't determine which value needs to be calculated then error throws out.
In your scenario, you can use Summarize() function to create a new table with necessary columns then create a calculated table instead.
Best Regards,
Qiuyun Yu
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.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |