Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hello, I have the following model where I can't get the calculate function to work properly.
I am trying to calculate the sum of the Amount column in the ApplyMBI Payments table. My measure is:
total amount = CALCULATE(SUM('ApplyMBI Payments'[Amount]))
Any direction is appreciated.
Solved! Go to Solution.
Hello, you won't need a measure to sum a value in visualizations. When you add a "numeric" column to a visualization it has the possibility to sum, average, min, max, etc.
Let's asume you need to create the measure anyway. The calculate is not necessary you can just SUM('ApplyMBI Payments'[Amount]). Calculate is for hard calculation.
Regards,
Happy to help!
Hi @johnchill,
In my opinion, it seems that you want to sum all of the 'ApplyMBI Payments'[Amount], right?
You can consider adding ALL() or ALLSELECTED() function inside of the CALCULATE(). See:
total amount = CALCULATE(SUM('ApplyMBI Payments'[Amount]), ALL('ApplyMBI Payments'))
Best Regards,
Qiuyun Yu
You will have to clarify what is not working.
While the CALCULATE isn't needed, it shouldn't really hurt you either.
total amount = SUM('ApplyMBI Payments'[Amount])
That is totally correct...
Hello, you won't need a measure to sum a value in visualizations. When you add a "numeric" column to a visualization it has the possibility to sum, average, min, max, etc.
Let's asume you need to create the measure anyway. The calculate is not necessary you can just SUM('ApplyMBI Payments'[Amount]). Calculate is for hard calculation.
Regards,
Happy to help!
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
67 | |
67 | |
42 | |
42 |
User | Count |
---|---|
46 | |
40 | |
28 | |
27 | |
26 |