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 return that I have 2 active Customers A and C
How could I do it?
3 Replies
Hello Syndicate_Admin ,
Try this
Measure = CALCULATE(DISTINCTCOUNT(cliente),(estado Cliente) = "Activo")If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
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.
Thank you very much, solved!
