Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
@maheshchubb123 , 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"))
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
@maheshchubb123 , 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"))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |