Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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...
Solved! Go to 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])
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
Proud to be a Super User!
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |