Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I dont understand what do code Grand Total= Calculate([Total obtained marks], ALL (Marks[Subject])) ? Please check screen shot. Calculate removes filters in visual and I dont understand what ALL do. It removes the same filter as calculate subjects???
Solved! Go to Solution.
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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @markovuc ,
The formular calculates the Grand Total by using the [Total obtained marks] measure and removing the applied filter to Marks[Subject] (due to "ALL()" )
That is why your visual shows the same number for all subjects in the Grand total column. PBI applies a filter to each row of your table, namely where Marks[Subject] = "Bio" for row 1, Marks[Subject] = "Computer" for row 2 etc. Now the ALL() function makes your Grand Total measure disregard that exact filter and therefore it shows 355 for all rows whereas the filter for the other measure [Total obtained marks] is still being applied.
hope this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |