Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi I Have a calculation I'm doing
TotalItems-TotalErrors/Totals Items
When doing this I'm get a number way off as seen in the "column"
Any help ?
Solved! Go to Solution.
Tough to say perhaps, but I would try this:
([TotalItems] - [TotalErrors]) / [Totals Items]
Even better:
DIVIDE( [TotalItems] - [TotalErrors], [Total Items],0)
Assumes those are all measures or all columns if you are creating a column in a table.
Hi @rutabah12,
Whether your expected result is to get the ratio of the number of correct items to the total number of items? If yes, you can replace the previous formula with the below one: (Suppose that the field TotalErrors and TotalItems are the aggregated values from the calculated columns or measure )
Column = ( [TotalItems]- [TotalErrors] ) / [TotalItems] |
If you still can’t get the correct results after replaced, please provide your data model structure and the formulas applied in the field TotalErrors and TotalItems. Thank you.
Best Regards
Rena
@Anonymous , if your issue has resolved from the above solutions, mark the solution.
Hi @Anonymous,
Whether your expected result is to get the ratio of the number of correct items to the total number of items? If yes, you can replace the previous formula with the below one: (Suppose that the field TotalErrors and TotalItems are the aggregated values from the calculated columns or measure )
Column = ( [TotalItems]- [TotalErrors] ) / [TotalItems
If you still can’t get the correct results after replaced, please provide your data model structure and the formulas applied in the field TotalErrors and TotalItems. Thank you.
Best Regards
Rena
Tough to say perhaps, but I would try this:
([TotalItems] - [TotalErrors]) / [Totals Items]
Even better:
DIVIDE( [TotalItems] - [TotalErrors], [Total Items],0)
Assumes those are all measures or all columns if you are creating a column in a table.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |