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.
ATTR([Incoming Tracers (Incoming Tracers)].[Tracer #])
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.