cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Measures for NBA Analysis

Hi community 🙂 I am new in Power BI and I got a very difficult exercise about the NBA and I need some help with DAX. I have 2 tables with Teams and Player's information on the total of points per player/team, converted/not converted points of 2 and 3, rebounds, turnovers, etc... (they are all in Portuguese).

Some parts I need help with:

1. I'm trying to create the PERCENTUAL of points of 2, 3, and free throws that must worth and I change the panel from teams to players, just like the example below (1 Team, 2 Players Individually):

I have already use the DIVIDE formula, like this:

But this formula returns me the PERCENTUAL of the TOTAL I guess, but it's different from the result above (both of the results are from the Miami Heat Team);

3ptteste = var totalptsgeral = CALCULATE(
F_JogadoresArremessos[Convertido (1 = sim , 0 = não)] = 1)
return
DIVIDE(Medidas[M 3PTS], totalptsgeral, 0)

2. I need the AVERAGE of Steals, Turnovers, faults, rebounds, and PPG (Points per Game), I think the same formula would worth for all these contents that the report needs. The problem is that I got only 1 table with dates "F_JogadoresArremessos", with all player's throw of 2 and 3 points (so I can do the PPG), but not with each rebound, turnover as the exercise asks to do, I got really stuck and I don't know how to do it. Here's the formula I used for PPG, the problem is the same, results don't match;

M PPJ = AVERAGEX(VALUES(F_JogadoresArremessos[Data do Jogo]),[M PTS Totais])

//sum of points of 2 and 3
M PTS Totais = Medidas[M 2PTS] + Medidas[M 3PTS]

//Total of converted points of 3

3. The last question should be very simple, haha, It is how can I do this visualization below;

I'll be very grateful if someone helps me with these questions if even answer one of them, it would help me a lot ❤️

If you have a PBIX of any NBA Data Report, share it with me, please! It will help me too 😄

(Sorry if you got confused with the language, I used Google Translator)

Here's the database:

Super User

For the graphic you can use the HTML5 custom visual and you create your data points in SVG format.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors