Creating a calculated table with DAX Studio

Use DAX Studio to write and test the expression for a calculated table in Power BI.

[samaguire]

Loving the videos! Thanks for sharing.

[FitofnietOfficial]

Hi Marco, thank you for your great content as always.

I’m wondering when should I use the“calculated table” function instead of “filter”?

Thanks!

[azzazin]

If I have a table or a matrix visualization with a set of columns and measures (I have around 30 columns and measures)- then how do I use the table as a new data source for another visual within the same pbix file and refresh automatically from the Power BI service?

[usmantariq]

Hi Marco, im really confused and unable to understand auto exists in summarize columns even after going through your explanation on sqlbi. Im not able to understand the COMBINED/MERGED filters you talk about. Any help or link you could provide which could help me in understanding this. Thx

[joseluischamblas]

How can I group by month a calculatetable ?
I try this:
DEFINE
TABLE Tabla =
SUMMARIZECOLUMNS (
Tabla1[ORDER_STATE],
MONTH(Tabla1[DATE]), //Here is my error
"ORDENES", DISTINCTCOUNT ( Tabla1[ORDER_ID] )
)

EVALUATE
CALCULATETABLE ( Tabla, Tabla[ORDER_STATE] = "INCIDENT_OPEN" )

Greeting from Chile

[guillaumeledique]

Thank you for this video. Quick question, to which I am pretty sure I know the answer however I want to be certain; once the table has been created this is a static table right?

[zxccxz]

will creating a calculated table slow down refreshes? It is unclear what FULL PROCESSING of a large fact table does.

[thomasschaub]

Hi Marco - what if you’ve created a measure in DAX studio as part of your expression?

[SirTupsAlot]

You forgot to include the step where you try to link the new table to the data model and get a circular reference error and then you google that and see some cryptic ideas about using "Distinct" to try to break the hidden connection to some source table and then that doesn't work so you give up on your calculated table. :(

(but seriously, a video on how to prevent the circular reference errors would be great!)