Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi all,
Assuming I want to display Revenue by a category, such as year.
What is the difference between the following two options:
Are there any differences from a result and design perspective? I'm aware that I'm more flexible by using a measure when it comes to row and filter context. But are there more reasons to use the measure instead of the summarized column?
Thanks.
Solved! Go to Solution.
From a result perspective : no difference.
From a design perspective : for simple, quick visuals , it's fine to use default summarisations . For anything else, writing measures gives more control, can aid reuse (though be careful on this), and aids self documentation.
From a result perspective : no difference.
From a design perspective : for simple, quick visuals , it's fine to use default summarisations . For anything else, writing measures gives more control, can aid reuse (though be careful on this), and aids self documentation.
Thanks, that helps!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |