subtitlecat.com

All language subtitles for 5. RECAP Calculated Columns vs. DAX Measures

Afrikaans

Akan

Albanian

Amharic

Arabic Download

Armenian

Azerbaijani

Basque

Belarusian

Bemba

Bengali

Bihari

Bosnian

Breton

Bulgarian

Cambodian

Catalan

Cebuano

Cherokee

Chichewa

Chinese (Simplified)

Chinese (Traditional)

Corsican

Croatian

Czech

Danish

Dutch

English

Esperanto

Estonian

Ewe

Faroese

Filipino

Finnish

French

Frisian

Galician

Georgian

German

Greek

Guarani

Gujarati

Haitian Creole

Hausa

Hawaiian

Hebrew

Hindi

Hmong

Hungarian

Icelandic

Igbo

Indonesian

Interlingua

Irish

Italian

Japanese

Javanese

Kannada

Kazakh

Kinyarwanda

Kirundi

Kongo

Korean

Krio (Sierra Leone)

Kurdish

Kurdish (Soranî)

Kyrgyz

Laothian

Latin

Latvian

Lingala

Lithuanian

Lozi

Luganda

Luo

Luxembourgish

Macedonian

Malagasy

Malay

Malayalam

Maltese

Maori

Marathi

Mauritian Creole

Moldavian

Mongolian

Myanmar (Burmese)

Montenegrin

Nepali

Nigerian Pidgin

Northern Sotho

Norwegian

Norwegian (Nynorsk)

Occitan

Oriya

Oromo

Pashto

Persian

Polish

Portuguese (Brazil)

Portuguese (Portugal)

Punjabi

Quechua

Romanian

Romansh

Runyakitara

Russian

Samoan

Scots Gaelic

Serbian

Serbo-Croatian

Sesotho

Setswana

Seychellois Creole

Shona

Sindhi

Sinhalese

Slovak

Slovenian

Somali

Spanish

Spanish (Latin American)

Sundanese

Swahili

Swedish

Tajik

Tamil

Tatar

Telugu

Thai

Tigrinya

Tonga

Tshiluba

Tumbuka

Turkish

Turkmen

Twi

Uighur

Ukrainian

Urdu

Uzbek

Vietnamese

Welsh

Wolof

Xhosa

Yiddish

Yoruba

Zulu

Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated: 1 00:00:00,760 --> 00:00:07,260 Let's take a minute and walk through a quick recap of calculated columns versus measures in one place. 2 00:00:07,360 --> 00:00:13,330 So on the calculated column side these values are calculated based on information from each row of the 3 00:00:13,330 --> 00:00:14,050 table. 4 00:00:14,260 --> 00:00:21,730 They have row context measures are calculated based on information from filters in the report they have 5 00:00:21,730 --> 00:00:24,890 filter context calculated columns. 6 00:00:24,890 --> 00:00:31,240 Actually append static values to each row in the table and it stores them in those tables within your 7 00:00:31,240 --> 00:00:32,080 model. 8 00:00:32,080 --> 00:00:35,210 This increases the file size measures. 9 00:00:35,210 --> 00:00:39,110 On the other hand don't create new data in the tables themselves. 10 00:00:39,350 --> 00:00:46,280 Therefore they don't increase file size in your model calculated columns recalculate on data source 11 00:00:46,370 --> 00:00:53,300 refresh or whenever changes are made to the component columns in the calculation measures or recalculate 12 00:00:53,360 --> 00:00:57,440 in response to any change to filters within the report. 13 00:00:57,440 --> 00:01:04,430 In other words any time that filter context changes and then calculated columns are primarily used for 14 00:01:04,430 --> 00:01:11,170 things like rows columns slicers or filters you often use them as dimensions to change the way you're 15 00:01:11,180 --> 00:01:18,410 viewing your data whereas measures are almost always used within the values field of a visual. 16 00:01:18,440 --> 00:01:25,130 So when you create calculated columns they live inside of the tables and when you create measures those 17 00:01:25,130 --> 00:01:28,680 measured values live within the visuals. 18 00:01:28,730 --> 00:01:33,470 So there you have it quick cheat sheet pre-calculated columns versus daks measures. 2029