cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

## How to create an measure for the data

Hello Everyone,

I would like to take a measure for this data. Can anyone help me with what kind of measure I can create for this data? The below data is football world cup data and the tables are goalkeeper score for team, defence score, offensive score, midfield score

team                   goal  defense offense midfield

 Argentina 84 82 89 84 Australia 77 72 72 74 Belgium 89 81 86 86 Brazil 89 87 87 86 Cameroon 67 77 78 75 Canada 76 69 73 78 Costa Rica 88 72 70 69 Croatia 82 78 77 84 Denmark 85 80 78 80 Ecuador 71 74 76 74 England 83 85 88 84 France 87 84 87 86 Germany 88 84 83 86 Ghana 74 76 76 78 IR Iran 73 69 75 69 Japan 73 75 75 78 Korea Republic 75 73 80 74 Mexico 80 77 83 78 Morocco 82 81 82 76 Netherlands 81 85 83 84 Poland 87 75 85 76 Portugal 82 85 86 84 Qatar 50 78 80 79 Saudi Arabia 70 73 68 73 Senegal 83 79 81 79 Serbia 80 76 80 82 Spain 84 86 85 86 Switzerland 85 78 77 80 Tunisia 64 71 72 74 USA 77 76 78 76 Uruguay 80 81 84 80 Wales 74 75 73 78
1 ACCEPTED SOLUTION
Community Support

Hi @VenkatC ,

You can do a lot of calculations.

Here are some commonly used functions.

MAX function (DAX) - DAX | Microsoft Learn

MIN function (DAX) - DAX | Microsoft Learn

SUM function (DAX) - DAX | Microsoft Learn

AVERAGE function (DAX) - DAX | Microsoft Learn

More complex calculations require you to provide specific needs.

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Community Support

Hi @VenkatC ,

You can do a lot of calculations.

Here are some commonly used functions.

MAX function (DAX) - DAX | Microsoft Learn

MIN function (DAX) - DAX | Microsoft Learn

SUM function (DAX) - DAX | Microsoft Learn

AVERAGE function (DAX) - DAX | Microsoft Learn

More complex calculations require you to provide specific needs.

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors