Group Column with Conditions

Hi schoden ，

You can follow these steps：

Step 1,import data you provide:

Step 2,use the following dax to create a new table:

Table 2 = SUMMARIZE('Table','Table'[Name],"missing value",CALCULATE( count('Table'[Term]),FILTER('Table','Table'[Term]="missing")))

Step 3，create new column in the new table :

about =

IF ( 'Table 2'[missing value] = blank(), "full",

IF ( 'Table 2'[missing value] >=1 &&'Table 2'[missing value] <=2, "1-2 Missing",

IF ( 'Table 2'[missing value] >=3 &&'Table 2'[missing value] <=4, "3-4 Missing",

IF ( 'Table 2'[missing value] >=5 , ">5 Missing"

) ) ) )

about2 = IF ( 'Table 2'[about] ="full", "full","missing")

Step 4，try the following measure:

About4 =

VAR about3 =

CALCULATE (

COUNT('Table 2'[about]),

FILTER (

ALL ( 'Table 2' ),

'Table 2'[missing value]<>BLANK()&&'Table 2'[about]=MAX('Table 2'[about]))

)

RETURN

( about3 )

Step 5,create visual base on the new table , Finally you will see:

If my answer helps you, you can mark it as an answer, thank you!

Best Regards,

Lucien