Measure count active customers

[Syndicate_Admin]

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?

[Syndicate_Admin]

Thank you very much, solved!

[confidentnwrong]

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.

[Idrissshatila]

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 👍

Follow me on Linkedin