Show max and min from a filtered list as KPI

[troyel]

Hi,

I have a data set where I have numerator and denominators in different columns (and rows) for different projects. 

I use a measure to calculate the resulting percentage of these figures. ((SUM(Table[Numerator])/SUM(Table[Denominator])))

Currently when I view these results they are just the sum of all projects numerator divided by the sum of all projects denominator. What I want to get are the max, min and average of these - for each project as a KPI/single figure. How can I do this? See example data set in excel.

Thanks!

Results I want in the measure is highligted in yellow:

[Anonymous · Accepted solution]

HI @troyel,

You can try to use below formulas if it suitable for your requirement.

Summary table and calculate the percent:

Summary =
ADDCOLUMNS (
    SUMMARIZE (
        Table1,
        [Project],
        "Value", SUM ( Table1[Value] ),
        "Denominator", SUM ( Table1[Denominator] )
    ),
    "Percent", [Value] / [Denominator]
)

Measures:

AVG=AVERAGE(Summary[Percent])
MAX=MAX(Summary[Percent])
MIN=MIN(Summary[Percent])

Regards,

Xiaoxin Sheng

[troyel]

Ah -  I had not considered creating a separate table to do this. Smart - thank you!