Power BI Simulator — Learn DAX & Dashboards 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

🔗 Manage table relationships

⚡ + 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()

Sum of a column

AVERAGE()

Average

MAX()

Maximum value

MIN()

Minimum value

COUNT()

Count values

COUNTROWS()

Count rows

DISTINCTCOUNT()

Count unique values

Table

FILTER()

Filter by condition

SUMMARIZE()

GROUP BY + aggregation

ADDCOLUMNS()

Add calculated columns

SELECTCOLUMNS()

Select specific columns

TOPN()

Top N rows

VALUES()

Unique values

DISTINCT()

No duplicates

UNION()

Union of tables

INTERSECT()

Intersection of tables

EXCEPT()

Difference of tables

CROSSJOIN()

Cartesian product

Calculation & filter

CALCULATE()

Calculation with a filter

ALL()

Remove all filters

ALLEXCEPT()

Remove filters except...

RELATED()

Value from a related table

EARLIER()

Value from the outer loop

RANKX()

Rank rows

DIVIDE()

Safe division

Logic

IF()

Condition

SWITCH()

CASE WHEN

IFERROR()

Error handling

ISBLANK()

Check for blank

Math & text

ROUND()

Rounding

ABS()

Absolute value

CONCATENATE()

Concatenate strings

LEN()

String length

UPPER()

Uppercase

📋 Ready-made examples

Total PTS

Sum + average + peak

Avg by Team

Average by team

Top 10 Scorers

Top 10

Filter PTS>25

Filter players

Home Win %

Home win %

Triple Doubles

PTS+TRB+AST≥10

ADDCOLUMNS

Calculated columns

RANKX

Rank players

IF Tiers

Classify players

SWITCH Levels

4 levels

SELECTCOLUMNS

Select columns

SUM()

Sum of a column

COUNT()

Count rows

MAX()

Maximum value

MIN()

Minimum value

COUNTROWS()

Count rows in a table

FILTER()

Filter a table by condition

SUMMARIZE()

Group & aggregate

CALCULATE()

Calculation with a filter

TOPN()

Top N rows

RANKX()

Rank rows

IF()

Logical condition

DIVIDE()

Safe division

DISTINCTCOUNT()

Count unique values

RELATED()

Value from a related table

ALL()

Remove all filters

ALLEXCEPT()

Remove filters except...

EARLIER()

Value from the outer loop

SWITCH()

DAX CASE WHEN

DATESBETWEEN()

Date range

📋 Total PTS

Example: sum of points

📋 Avg by Team

Example: average per team

📋 Top 10 Scorers

Example: top 10

📋 Filter PTS>30

Example: filter players

📋 Home Win %

Example: win %

📋 Triple Doubles

Example: Triple-Doubles

📊 Result Waiting to run...

Run DAX to see results

🔍 Active filters:

None — click a chart or Slicer

← Click a visualization in the left panel

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

📄 Page 1

📊 Visualizations

Build a visual

Bars

Lines

Pie

Doughnut

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