Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I've seen numerous posts on this topic that all seem to indicate the need for a measure instead of calculated column. I am using measures but still getting incorrect results. I am trying to dive the sum of Annual Expense by the sum of Book Value to get a ratio of expense to assets under management.
This seems so simple, but I am not getting correct results. The DAX formula I am using is as follows:
Thanks for the replies from lbendlin and rmateo.
Hi @mwebergo2 ,
Have you solved your problem? If it is solved, please share your solution and accept it as solution or mark the helpful replies, it will be helpful for other members of the community who have similar problems as yours to solve it faster. Thank you very much for your kind cooperation!
Best Regards,
Zhu
Verify Relationships:
Test Individual Components:
Validate Filter Context:
Row-Level Aggregation Check:
If your data model has no issues and you simply need the correct context for the division:
If Tables Are Not Related: Use CROSSFILTER or ALL to manipulate filter context:
If You Need a Weighted Average: Use a more complex formula to handle weighting:
If the issue persists, share details about the data relationships, granularity, or any specific filters that may affect calculations.
Here's a snip of the dashboard. The expense ratio card (circled in blue) is the measure I am trying to depict. It is the results of dividing the two cards just above it.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
No
Do you display that measure next to a column from the Calendar Table?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
8 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
9 |