Forum Discussion
What this code actailly do?
Imagine you have a formula to calculate the total marks obtained, and it takes into account different subjects. Now, if you use the CALCULATE function with ALL(Marks[Subject]) as an argument, it's like telling the formula to ignore the influence of the subject filter. So, on each row, you get the total marks without being influenced by the specific subject, giving you a broader picture across all subjects.
Hope that clarifies it! If you have any specific questions or need more examples, feel free to ask.
markovuc
In your formula, Caculate is used to modify how your measure [Total obtained marks] is evaluated. By applying ALL (Marks[Subject]) as an argument to the Calculate functon, it removes the filter coming from Subject column, that is the reason on each row, you see the total amount where [Total obtained marks] is not affected by subject.
Hi guys, many thanks for your replies. Happy 2024.! I dont understand following sentence "In your formula, Caculate is used to modify how your measure [Total obtained marks] is evaluated."How the measure is evaluated with calculate and without ?
I still dont understand what Calculate do? How Calculate operate.
Imagine you have a formula to calculate the total marks obtained, and it takes into account different subjects. Now, if you use the CALCULATE function with ALL(Marks[Subject]) as an argument, it's like telling the formula to ignore the influence of the subject filter. So, on each row, you get the total marks without being influenced by the specific subject, giving you a broader picture across all subjects.
Hope that clarifies it! If you have any specific questions or need more examples, feel free to ask.