Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Duplicate rows affecting total

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...

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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])

2 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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])