Power BI Simulator — Learn DAX and Dashboards for Free | SQL.course

𝒇𝒙

DAX

⏱ Performance Log ✕

Click "⏱ Performance" to start recording

🔍 Filters Pane ✕

💡 Drag a field from the right panel to one of the Drop zones below.

Filters on this visual

drag a field

Filters on this page

drag a field

Filters on the whole report

drag a field

📋 Fields — NBA Data

👆 Long-press a field to drag it

🔗 Managing Relationships Between Tables

⚡ + new calculated table

🏀 game_info

∑game_id

∑season

📅date

Aaway_team

∑away_score

Ahome_team

∑home_score

∑result

⚡+ calculated column

𝒇𝒙+ create new measure

👤 player_stats

Aplayer

Ateam

∑PTS

∑AST

∑TRB

∑STL

∑BLK

∑TOV

∑FGp

⚡+ calculated column

𝒇𝒙+ create new measure

🏆 team_stats

Ateam

∑PTS

∑FGp

∑3P

∑AST

∑TRB

⚡+ calculated column

𝒇𝒙+ create new measure

📐 DAX Editor — write a DAX formula

📚 DAX functions

aggregation

SUM()

Column sum

AVERAGE()

average

MAX()

Maximum value

MIN()

Minimum value

COUNT()

Value count

COUNTROWS()

Row count

DISTINCTCOUNT()

Counting unique values

table

FILTER()

Filter by condition

SUMMARIZE()

GROUP BY + aggregation

ADDCOLUMNS()

Add calculated columns

SELECTCOLUMNS()

Select specific columns

TOPN()

N first rows

VALUES()

Unique values

DISTINCT()

No duplicates

UNION()

Merging tables

INTERSECT()

Table intersection

EXCEPT()

Table difference

CROSSJOIN()

Cartesian product

Calculation and filter

CALCULATE()

Calculation with a filter

ALL()

Remove all filters

ALLEXCEPT()

Remove filters except...

RELATED()

A value from a related table

EARLIER()

A value from the outer circle

RANKX()

Row ranking

DIVIDE()

Safe division

logic

IF()

condition

SWITCH()

CASE WHEN

IFERROR()

Error handling

ISBLANK()

Empty check

Math and text

ROUND()

rounding

ABS()

Absolute value

CONCATENATE()

String concatenation

LEN()

String length

UPPER()

Uppercase letters

📋 Ready-made examples

Total PTS

Sum + average + peak

Avg by Team

Average by group

Top 10 Scorers

The top 10

Filter PTS>25

Filtering players

Home Win %

Home win percentage

Triple Doubles

PTS+TRB+AST≥10

ADDCOLUMNS

Calculated columns

RANKX

Player ranking

IF Tiers

Player classification

SWITCH Levels

4 levels

SELECTCOLUMNS

Select columns

SUM()

Column sum

COUNT()

Row count

MAX()

Maximum value

MIN()

Minimum value

COUNTROWS()

Counting rows in a table

FILTER()

Filtering a table by condition

SUMMARIZE()

Grouping and aggregation

CALCULATE()

Calculation with a filter

TOPN()

N first rows

RANKX()

Row ranking

IF()

Logical condition

DIVIDE()

Safe division

DISTINCTCOUNT()

Counting unique values

RELATED()

A value from a related table

ALL()

Remove all filters

ALLEXCEPT()

Remove filters except...

EARLIER()

A value from the outer circle

SWITCH()

DAX's CASE WHEN

DATESBETWEEN()

Date range

📋 Total PTS

Example: sum of points

📋 Avg by Team

Example: average per group

📋 Top 10 Scorers

Example: the top 10

📋 Filter PTS>30

Example: filtering players

📋 Home Win %

Example: win percentage

📋 Triple Doubles

Example: Triple-Doubles

📊 result Waiting to run...

Run DAX to see results

🔍 Active filters:

None — click on a chart or Slicer

← Click a visualization in the left panel

26 available visualizations:
Bar · Line · Pie · KPI · Map · Treemap · Funnel · and 19 more

📄 page 1

📊 Visualizations

Building a visual

columns

lines

cake

donut

KPI

table

area

scatter

Card

Gauge

Matrix

waterfall

Slicer

Stacked Col

Stacked Bar

100% Col

Clustered

Stacked Area

Combo

Funnel

Treemap

Ribbon

Multi Card

Map

Filled Map

Decomp Tree

Parameter

Text Box

Shape

Button

selected: Choose a visualization

📐 Values · fields

Choose a visualization above
To edit fields