[Power BI] Differences Between Physical Table and Virtual Table

Physical Table

  • Relationship View: The bottom icon on the left side of your page. Here you can create the relationship between tables.
Physical Tables in the Relationship View
  • Create by using DAX function such as SUMMARIZECOLUMNS, ALL.
    A DAX created table is also known as Calculated Table. (As the name speak for itself.)

Virtual Table

  • Here are some DAX you use to create virtual tables. Virtual tables are used together with other DAX functions.
    (1) FILTER(<Table>,<filter>)
    (2) VALUES(<TableName> or <ColumnName>)
    (3) DISTINCT(<TableName> or <ColumnName>)
    (4) SUMMARIZE(<table>,
    [<groupBy_columnName>],…,
    [<name>, <expression>],…)

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store