Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ena1309
Contributor III

Record count by specific dimension

Heyy guys,

I need measure for record count, but on a specific dimension? 
Because when i do rowNo() it always returns 0.

I have dimensions: country, company code, storage location and i want for each combination - number of records. 

Thank you in advance ! 
Ena

Labels (1)
1 Reply
marcus_sommer

You could use something like this: count(distinct Field) and by counting multiple dimensions: count(distinct Field1&Field2&Field3). If your other chart-expressions contain any filters you would need to use them within the count(), too.

- Marcus