Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Stijn123
Regular Visitor

Retrieve automatically calculated Total value for future calculations

Dear community,

 

I have a table that is subjected to many filters and I want the value that is calculated by the automatically calculated Total row as a separate measure. I added a screenshot of a random table to show which Total value I mean. Does anyone know how to get this value so I can use it for future caculations? The value will change of course by filters used. Thank you very much in advance!

 

Kind regards,

Stijn

Stijn123_2-1697643820271.png

 

3 REPLIES 3
Stijn123
Regular Visitor

Thank you very much for your reply! Unfortunately this does not work since the table is filtered with multiple measures and your solution provides only the total sum of all the values in that column. Another answer would be very much appriciated!

123abc
Community Champion
Community Champion

I understand that you need to calculate the Total value considering the filters applied by multiple measures, not just a simple sum of the column. To achieve this, you can use the "ALL" and "FILTER" DAX functions to remove the filters applied by other measures and then calculate the Total value.

Here's a general approach to do this in Power BI:

Assuming you have multiple measures (Measure1, Measure2, etc.) that filter your table, and you want to calculate the Total value based on these filtered measures:

  1. Create a new DAX measure for the Total value. You'll use the "ALL" and "FILTER" functions to remove the filters and then calculate the total. For example:

Total Value = CALCULATE(
[YourCalculationMeasure], -- Replace with your calculation logic
ALL(YourTable), -- Remove all filters from the table
FILTER(YourTable, NOT(ISBLANK([YourMeasure1]))) &&
FILTER(YourTable, NOT(ISBLANK([YourMeasure2]))) &&
... -- Repeat for all relevant measures
)

 

Replace [YourCalculationMeasure] with your calculation logic, and [YourTable], [YourMeasure1], [YourMeasure2], etc., with the appropriate table and measure names that are relevant to your scenario.

  1. Place this "Total Value" measure in a card visual in your report.

  2. As you apply filters using the multiple measures, the "Total Value" measure will consider these filters and calculate the Total accordingly.

This approach uses the CALCULATE function with the ALL and FILTER functions to create a measure that considers the filters applied by multiple measures and then calculates the Total value. The key is to use the FILTER function to check if the measures are not blank before applying the ALL function to remove the filters from the entire table.

This way, you can get the Total value that takes into account the filters from multiple measures and use it for future calculations. Adjust the DAX expressions as needed to fit your specific scenario.

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

 

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.

123abc
Community Champion
Community Champion

In Power BI, you can retrieve the automatically calculated Total value for a specific column in a table and use it for future calculations by creating a DAX (Data Analysis Expressions) measure. Here's how you can do that:

  1. Open your Power BI report and navigate to the Data view or the Fields pane.

  2. Locate the table in which you want to calculate the Total value.

  3. Create a new measure by going to the Modeling tab on the top menu and selecting "New Measure."

  4. Give your new measure a name. For example, let's call it "TotalValue."

  5. Write a DAX expression to calculate the Total value. You can use the SUMX function to sum the values in the column. Here's an example DAX expression

TotalValue = SUMX(YourTableName, YourTableName[YourColumnName])

 

Replace YourTableName with the actual name of your table and YourColumnName with the name of the column for which you want to calculate the Total value.

  1. Press Enter to create the measure.

  2. Now, you can use this "TotalValue" measure in your visualizations and for future calculations. It will automatically adjust based on the filters and selections you make in your report.

  3. To use this measure, simply drag and drop it into the Values area of a table, matrix, chart, or any other visual.

The "TotalValue" measure will dynamically recalculate the sum of the filtered data based on your report's context. This way, you can use the automatically calculated Total value for your future calculations in Power BI.

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

 

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.