Filter count max of column data

[Anonymous]

I have created a measure for a filter for my list of company Ids.

Filtered Count Company Id =

CALCULATE(

COUNT('looker_views lkr_Intake_Data'[Company_Id]),

filter('looker_views lkr_Intake_Data','looker_views lkr_Intake_Data'[Intake_Data_Custom_1] in {"COP1","COP2"}),

FILTER('looker_views lkr_Intake_Data','looker_views lkr_Intake_Data'[Intake_Data_Kill_Date] >= DATE(2019,04,01)

))

This gives me a list of company counts:

Supplier	3331
Supplier 1	2896
Supplier 2	2755

I'm trying to find the max of this filter (3331) and I have tried to create a new measure:

Max Filtered Count Company Id = MAXX('looker_views lkr_Intake_Data',[Filtered Count Company Id])

However I'm coming across an error when I try to insert this into the CARD visual.

Can anyone help?

[Greg_Deckler · Accepted solution]

@Anonymous I would think you would need to do something like:

Max Filtered Count Company Id =
VAR __Table =
  SUMMARIZE(
    'looker_views lkr_Intake_Date',
    [Company_Id],
    "Count",[Filtered Count Company Id]
  )
RETURN
  MAXX(__Table,[Count])

But it's a guess. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.