Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Measure count active customers

Hello good morning. I have a table in which are lines of orders but less this is the table: And I would like a measure that would give me back the active customers I have. I would have to r...
confidentnwrong's avatar
confidentnwrong
Icon for Advocate I rankAdvocate I
3 years ago

You can use Idrissshatila 's measure to count the number of active customers 

Measure = CALCULATE(DISTINCTCOUNT(cliente),(estado Cliente) = "Activo")

 

And use a slicer on the column estado Cliente to display them in the same table.

Note that if you'd like to only see the active clients and don't have a need to display the others on this page, you can directly put a filter "estado Cliente is Activo" on the table.