Totals are not coming correct

[pmahale]

Hi,

The total number of new customers is not correct. The total should be 32,261.

How to fix this? Please advise.

Thanks

[v-xiaotang]

Hi @pmahale 

Thanks for reaching out to us.

Could you please share a sample file for us to check the issue? Thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[pmahale]

Hi ,

Please refer to the file. The totals are not coming to be correct for new customers,existing customers,prior month customers.

https://drive.google.com/file/d/1p_JA0OQs9xVjsPOaLrr49nTh1-fhVsWv/view?usp=sharing 

Thanks

[Ashish_Mathur]

Hi,

That number may be correct because a customer in March may also be a customer in May.  In such a case, a simple addition will give the wrong answer.  If you need further help, then share the download link of the PBI file.

[pmahale]

Hi @Ashish_Mathur ,

Please refer to the attached file.

The totals are not coming correct.

https://drive.google.com/file/d/1p_JA0OQs9xVjsPOaLrr49nTh1-fhVsWv/view?usp=sharing 

Thanks

[Ashish_Mathur · Accepted solution]

Hi,

These are my measures

Date of first interaction = CALCULATE(MIN('Waterfall Data'[transdate]),DATESBETWEEN('Dim Date'[Date],MINX(ALL('Dim Date'),'Dim Date'[Date]),MAX('Dim Date'[Date])))

New cust = countrows(FILTER(values('Waterfall Data'[customerid]),[Date of first interaction]>=MIN('Dim Date'[Date])))

Hope this helps.

See the third column

[pmahale]

Thanks @Ashish_Mathur for your help. This works.

[Ashish_Mathur]

You are welcome.

[0leg]

hi @pmahale 

see if helps.🤗

Solved: Incorrect Totals in Measure - Microsoft Power BI Community

[VahidDM]

Hi @pmahale 

Is "new customers" a measure? It's a common issue, please check this blog:
https://www.vahiddm.com/post/why-my-measure-returns-the-wrong-total

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[pmahale]

Hi @VahidDM 

Please refer to the file. I am not getting the totals correct.

https://drive.google.com/file/d/1p_JA0OQs9xVjsPOaLrr49nTh1-fhVsWv/view?usp=sharing 

[Anonymous]

Hello @pmahale, please visit the link below:

https://youtu.be/ufHOOLdi_jk 

I hope it answer your question.