The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Is there a way to get the correct total of a column. I seem to be getting the wrong totals after exporting the visual to excel format.
I'd like some help if there's any sample forumula, the ones I saw doesn't seem to be up to date.
Certainly! In Power BI, you can use the DAX (Data Analysis Expressions) language to create calculated columns or measures for various purposes, including calculating totals for specific columns. If you're experiencing issues with incorrect totals after exporting to Excel, it might be related to the way the calculations are set up in your Power BI model.
Here's a basic example of how you can create a measure to calculate the total for a specific column in Power BI:
Let's assume you have a table called "YourTable" and a column called "YourColumn" that you want to sum up.
Create a Measure:
In the Fields pane, right-click on the table, select "New Measure," and enter the following DAX formula:
Total = SUM(YourTable[YourColumn])
Replace "YourTable" with the actual name of your table and "YourColumn" with the actual name of your column.
Display the Measure in a Visual:
Drag and drop the newly created measure ("Total") onto a visual (e.g., a card or a table) to display the total.
Verify the Results:
Check if the total displayed in Power BI matches your expectations. If it does, the issue might be related to the export to Excel.
Export to Excel:
When exporting to Excel, make sure you are exporting the data and not just a visual. Select the option to export the data, and then check the Excel file to see if the totals are correct.
If you are still facing issues with incorrect totals in Excel after exporting, it might be helpful to review the data in Power BI and check for any data transformations or filters that might affect the results.
If you have specific details about your table structure or any filters applied, feel free to provide more information, and I can offer more targeted assistance.
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |