Forum Discussion
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...
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.