Group by two columns and bind aggregated column to Guage

[Anonymous]

Data:

APIM	Date	Total runs	Failed Runs	Successful Runs
APIM 1	10/1/2020	100	10	90
APIM 1	10/2/2020	100	20	80
APIM 1	10/3/2020	100	30	70
APIM 1	10/4/2020	100	40	60
APIM 1	10/5/2020	100	50	50
APIM 1	10/6/2020	100	60	40
APIM 1	10/7/2020	100	70	30
APIM 1	10/8/2020	100	10	90
APIM 1	10/9/2020	100	20	80
APIM 1	10/10/2020	100	30	70
APIM 1	10/11/2020	100	40	60
APIM 1	10/12/2020	100	50	50
APIM 2	10/1/2020	100	10	90
APIM 2	10/2/2020	100	20	80
APIM 2	10/3/2020	100	30	70
APIM 2	10/4/2020	100	40	60
APIM 2	10/5/2020	100	50	50
APIM 2	10/6/2020	100	60	40
APIM 2	10/7/2020	100	70	30
APIM 2	10/8/2020	100	10	90
APIM 2	10/9/2020	100	20	80
APIM 2	10/10/2020	100	30	70
APIM 2	10/11/2020	100	40	60
APIM 2	10/12/2020	100	50	50
APIM 3	10/1/2020	100	10	90
APIM 3	10/2/2020	100	20	80
APIM 3	10/3/2020	100	30	70
APIM 3	10/4/2020	100	40	60
APIM 3	10/5/2020	100	50	50
APIM 3	10/6/2020	100	60	40
APIM 3	10/7/2020	100	70	30
APIM 3	10/8/2020	100	10	90
APIM 3	10/9/2020	100	20	80
APIM 3	10/10/2020	100	30	70
APIM 3	10/11/2020	100	40	60
APIM 3	10/12/2020	100	50	50

Requirement:

We want to display 3  controls i.e. "Guage"s to display Success Percentage for each of the APIMs i.e. APIM 1, APIM 2, APIM 3.

For example, APIM 1, we will calculate success percentage for all the dates and display that success percentage in a Guage.

Similarly for APIM 2 and APIM 3as well.

We are unable to find a solution to display. Please help!

[AlB]

Hi @Anonymous 

You can just place this measure in a gauge visual:

Measure = 
DIVIDE(SUM(Table1[Successful Runs]),SUM(Table1[Total runs])) 

and use the APIM column in a slice to select which one you want to see

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[amitchandak · Accepted solution]

@Anonymous , You can create a measure like this and use the visual level filter for APIM 

Success % = divide(sum(Table[Successful Runs]),sum(Table[Total runs]))

or create three measures

APIM 1 = calculate([Success % ], filter(Table,Table[APIM] ="APIM 1"))