Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

to count values ​​between two fields

I am trying to create a measure in which I can present a value that presents the information if a customer made a purchase in a company other than one that he has already bought ... and not only if he bought but also how many purchases he made ........ all the information is in the same table .... already tried everything but nothing so far.....


I think an if case can solve the problem but I do not know how to do it.



This is the measure I'm trying to create:


Cotave = CALCULATE ( [Qtd. Active clients]; 'PBI_FAT_TT' [COMPANY NAME] IN {"Cotave", "Elmaz" )


[Qtd. Active clients]; shows the number of customers and "Cotave" and "Elmaz" are the companies Qty Active Customers for 

Community Support
Community Support



You may check if the following post helps.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources


Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.


Power BI Women

Join our monthly meetings and learning sessions.



We are excited to announce the Power BI Super Users!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors