Regarding the column of the data type text to be use in the measure calculation

[AnilKumar]

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

[v-qiuyu-msft]

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