Calculating max of two columns from separate tables

[Anonymous]

I have two tables (Supplier and Data)

Supplier contains the supplier name 

Data contains the count of company id

As they are related I'm able to create a table like:

Supplier Name	Company Id
Supplier 1	3232
Supplier 2	3150
Supplier 3	2994
Supplier 4	2756
Supplier 5	2500

I'm trying to find a measure to calculate the max i.e. 3232 so I can place it in a card.

Can anyone help?

[Anonymous]

Probably something like this:

[Max ID] =
	CALCULATE(
		MAX( Data[CompanyID] ),
		ALLSELECTED( )
	)

Best

D

[Pragati11]

Hi @Anonymous ,

Assuming that your COMPANY ID column is in numeric format,

On the card visual move COMPANY ID column and set aggregation to MAX.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati