Having trouble with total averages

Hi  cathoms  ,

This is the data I created:

Here are the steps you can follow：

1. Create measure.

Measure =
DIVIDE(MAX('All_Visits'[99212 Visits]),MAX('All_Visits'[Established Visit Total]))

Measure 2 =
VAR _1=
SUMX(FILTER(ALL('All_Visits'),'All_Visits'[Row labels]=MAX('All_Visits'[Row labels])),[Established Visit Total])
VAR _2=
SUMX(FILTER(ALL('All_Visits'),'All_Visits'[Row labels]=MAX('All_Visits'[Row labels])),[99212 Visits])
RETURN
DIVIDE(_2,_1)

Measure 3 = IF([Measure]<[Measure 2],1,0)

2. Result:

If my answer does not meet your expectations, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.