Table Visual Based on Highest Percentage

[sheap069]

Hi,

I have data with applications and groups. A single application can be part of many groups and one group can have many applications. There are applications that are refused. Sample data and the desired output is attached here.

I want to show application data based on the highest refusal percentage, and only show the Group ID that had the highest percentage, as follows. 

Application ID	Date	Country	Group ID	# Apps	# Refused Apps	Percent Refused
1	1/1/2021	Canada	2	4	4	100%
2	1/1/2022	Australia	2	4	4	100%
3	1/1/2023	France	2	4	4	100%
4	1/1/2024	Canada	1	6	3	50%
5	1/1/2025	India	1	6	3	50%
6	1/1/2026	USA	1	6	3	50%
7	1/1/2027	USA	4	8	1	12%
8	1/1/2028	Canada	2	4	4	100%
9	1/1/2029	China	2	4	4	100%
10	1/1/2030	China	3	4	1	25%
11	1/1/2031	Spain	4	8	1	12%

Right now, there is a line for each Group ID the Application ID is a member of (e.g. 4 lines for Application ID #1)

Thank you.

[Jihwan_Kim · Accepted solution]

Hi, @sheap069 

Please check the below picture and the sample pbix file's link down below.

All measures are in the sample pbix file.

https://www.dropbox.com/s/kiq9vvkjuucn1in/sheap.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[sheap069]

Hi,

Thank you very much, this solved the problem and I got the desired output.