Calculate Max not working

[VulcanPromance]

Hi.

I've just reshaped my datasets and I've created this table by merging my license table and my price table (the 3 righternmost columns)

Table Licenses

Based on this table I can get this Visual

Most of these numbers are correct. The price was added with a dont summarize and the Cost is a measure that
Summarize Price (    Cost = SUM(Licenses[Price])     )

The count I get by counting Distinct Count of corprateID from the licenses table

Count = DISTINCTCOUNT(Licenses[CorporateID])

But When I remove the LicenseType column I want to see just the number for Max License within each BundelName

See preferred Result

However, it aggregates all from Bundlename instead and the calculations on cost and count is all wrong.

[v-frfei-msft]

Hi @VulcanPromance ,

To create a measure as below.If it doesn't meet your requirement, kindly share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

countmax =
MAXX ( ALLEXCEPT ( yourtable, yourtable[Boundlename] ), [count] )

[VulcanPromance]

It contains confidential data.. I would have to create a sample and anonymize..

Meanwhile... your Measure just added a column full of '1's

I think the problem is the count measure.. Its a distinct count of all users(corporateid) regardless of license attached to it.. so for example the Facility Managment Bundle.. it contains 329 licenses, but only 258 distinct users. Im going to try to count it based on the licensetype instead of just counting distinct users..

Will send you link for anonymized data if it doesnt work 🙂