I have two different data sources which are connected by relationship. I am trying to create a count based on the other column which is a string. As there is not numeric values. When i trying to create the measure in the other datasource using ATTR and add it to measures, it gives me text not values.
Is there a way i could display the count. since ATTR is also an aggregate formula.
The COUNT function has some limitations when blending between two data sources (background here). You might be able to SUM the [Number of Records] field in the secondary data source to get the result you're going for.