cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PeORydgren Frequent Visitor
Frequent Visitor

How to count specific sums within a data set

I have a set of license values within a data set. I need to count the amount of customers which have a summarized total of AmountIn and AmountOut equals 0, meaning a lost customer.

 

So in this table below it would evaluate that only one of the customers is lost (A), since the others still have a balance different from zero.

 

Excel_Example.png

 

I am not cracking this one myself...

2 REPLIES 2
Highlighted
GauravSingh Regular Visitor
Regular Visitor

Re: How to count specific sums within a data set

Hi,

 

just make a new Measure by using the following dax

 

Lost_Customer = CALCULATE(COUNTA(Table1[Customer]), Table1[AmountIn] = 0)
PeORydgren Frequent Visitor
Frequent Visitor

Re: How to count specific sums within a data set


@GauravSingh wrote:

Hi,

 

just make a new Measure by using the following dax

 

Lost_Customer = CALCULATE(COUNTA(Table1[Customer]), Table1[AmountIn] = 0)


Thank you Gaurav. However, for customer C the summarized amount is not zero and the customer is not lost. (And I clarified in my description since I understand I was not 100% clear on the summarized values och both In and Out equal to zero.)

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 276 members 2,793 guests
Please welcome our newest community members: