Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.