thank you soo much well explained here's the notes: Calculated Column: - A calculated column is evaluated for each row. - Calculated columns do not work in filter context; they work on the whole dataset. - Calculated columns are pre-calculated. - A calculated column is computed when you first define it and during a dataset refresh. - Stored in memory (consumes RAM). ➙ Example of a calculated column: TotalSales = Sales[Quantity] * Sales[UnitPrice]. Measure: - A measure must contain an aggregation function such as AVG or SUM. - Measures work in filter context. - Measures are calculated on the fly. - Measures evaluate the value based on the subset of data selected by filters, slicers, or slicing and dicing components of visuals in the report. - Measures consume CPU, not RAM. ➙ Example of a measure: TotalSales = SUM(Sales[Amount]).
Sir i have seen more than 10 vdos on measure but i must say u did best .. what an explanation , material everything is good. Pls keep uploading vdos ..n i am surprise why people not watching this video.
thank you soo much well explained
here's the notes:
Calculated Column:
- A calculated column is evaluated for each row.
- Calculated columns do not work in filter context; they work on the whole dataset.
- Calculated columns are pre-calculated.
- A calculated column is computed when you first define it and during a dataset refresh.
- Stored in memory (consumes RAM).
➙ Example of a calculated column: TotalSales = Sales[Quantity] * Sales[UnitPrice].
Measure:
- A measure must contain an aggregation function such as AVG or SUM.
- Measures work in filter context.
- Measures are calculated on the fly.
- Measures evaluate the value based on the subset of data selected by filters, slicers, or slicing and dicing components of visuals in the report.
- Measures consume CPU, not RAM.
➙ Example of a measure: TotalSales = SUM(Sales[Amount]).
Very well explained. Thank you so much
I am totally speechless I have no words to say something unbelievable thanks you so much sir ❤
So nice of you
i was very confused and i am now very confidant for this topic thanks for this explaction .
Thanks
Sir i have seen more than 10 vdos on measure but i must say u did best .. what an explanation , material everything is good.
Pls keep uploading vdos ..n i am surprise why people not watching this video.
Thanks for liking. A Series of Power BI video and DAX functions is in pipeline
Best video till now.. Thank You Sir ❣️♥️🥰
Most welcome 😊
Best video on measure till now I seen clearly explained
thanks
Very well explained !!
Glad you liked it
thank you so much😇❤❤❤❤❤❤❤
Thanks
thank you so much well explained sir !
Most welcome!
Very well explained
Thanks
Excellent
Good video. Keep up the work sir!
Appreciate it!
Awesome!!!
Thank you! Cheers!
thanks
Welcome
best
Thanks
Best
thanks
Sir ye Excel files sales summary and all ka link attached kr dona practice k liye help ho jaegi yaa fir mail kr do sir please
I have added link in description for sample data downloading : education.lotusamaze.com/admin/download-data-file/sample-data.xlsx
@@lotusamaze1142 thank you so much sir