Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
Solved! Go to 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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Thank you very much, this solved the problem and I got the desired output.