Power BI Help - Top 2 Box

FanofExcel18

New Member
Joined
Jun 7, 2018
Messages
41
Issue: I have data that represents Survey's that I need to calculate in a Top 2 Box fashion for Power BI. I'm new to this and really trying to move towards this. Appreciate any help
Example: Scale of 1 to 5, only scores that matter are 4 and 5's. So if I have 10 scores: 1 = 2, 2=1, 3=1, 4=2, 5=4. My Top 2 box score is 4's(2/10) + 5's(4/10) = 60%
I can easily do this with a countif statement in Excel, but I'm trying to adapt to Power Bi and display this appropriately. =(COUNTIFS(A:A,E2,B:B,5)/COUNTIF(A:A,E2))+(COUNTIFS(A:A,E2,B:B,4)/COUNTIF(A:A,E2))

Here is sample data:
TeamScore
Team 15
Team 25
Team 32
Team 44
Team 55
Team 14
Team 21
Team 35
Team 45
Team 55
Team 15
Team 21
Team 35
Team 45
Team 55
Team 15
Team 25
Team 34
Team 45
Team 54
Team 14
Team 24
Team 35
Team 45
Team 55
Team 15
Team 25
Team 35
Team 44
Team 53
Team 14
I need the results to look like this:


TeamScore
Team 1
100%​
Team 2
67%​
Team 3
83%​
Team 4
100%​
Team 5
83%​
 

Forum statistics

Threads
1,078,117
Messages
5,338,322
Members
399,226
Latest member
arictarhvasiliev

Some videos you may like

This Week's Hot Topics

Top