Duplicate rows affecting total

[Anonymous]

Hi,

I am getting a nextra row which is coming up in my report table.

This is due ot the fact the name of the company was changed (from Australia to Australia Pty Ltd) causing the value to be diffeerent.

However, since this extra row is added it is affecting my total for this customer creating a double up.

I need to remove the other entry and keep 'Australia Pty Ltd'.

Currently my total is calculated by customer with a given date range:

MaxLicenseCount = CALCULATE([LicenseCountPerDay], FILTER(SubscriptionAnalyticsMerge, SubscriptionAnalyticsMerge[CreatedOnLocal] = MAX(SubscriptionAnalyticsMerge[CreatedOnLocal])))

Wat's the best way in doing this?

I think somehow I need to incorporate the Max license count measure to incorporate the distinct GUID - tenantid and maybe that should d othe trick? I am clearly not a PowerBi expert...

[Nathaniel_C]

Hi @Anonymous ,

I am assuming that you will change it in [LicenseCountPerDay], which you don't show us, but using the ID as it a unique identifier sounds like the way to go.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Anonymous · Accepted solution]

The problem was that the CSP name had multiple values.

I just created a meaure to get the max of this field and used this as a display column for my table and that resolved it.

DistinctName = max(SubscriptionAnalyticsMerge[SubscriptionAnalyticsDetail.kpmg_cspcustomername])