cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Stanza Member
Member

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.

 

Duplicate PowerBI.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
Stanza Member
Member

Re: Duplicate rows affecting total

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

View solution in original post

2 REPLIES 2
Super User IV
Super User IV

Re: Duplicate rows affecting total

Hi @Stanza ,

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Stanza Member
Member

Re: Duplicate rows affecting total

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

View solution in original post

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors