cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III

## Make a measure for the sum of the total of a column

Hello guys, how are you?

I have a table, in it I have 3 columns referring to information from various equipment, these columns receive various information during the day, but this information is always the value 5, so the cell will either be blank or have the value 5:

I need to add the information from the columns to get the total in a day, in order to identify how many equipment generated more events from each column in a day, for that I created a TOTAL column that adds the information from the 3 columns

I put a bar graph to quickly generate the information of the quantities and a Matrix to show the amounts of events per day and by equipment, however I needed some way that in the bar graph only the equipment that generated above 300 events a day, I put them with the value in red in the matrix, but it causes confusion because it differs from the amount that is in the bar graph, how could I add this information and filter only above a value and put it in the bar graph?

Can anybody help me? Thank you very much in advance!

1 ACCEPTED SOLUTION
Community Support

Hi @diegolima,

Account to your description, it sounds like a common measure formula calculate with multiple level aggregates.

If that is the case, I'd like to suggest you create a variable with summarize function to aggerated first level calculations, then you can add filter on the variable table to add filter condition on these aggregated results and use iterator function(e.g. sumx, averagex...) to apply the second level aggregations.

(e.g. aggregated values above 300)

Measure Totals, The Final Word
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Community Support

Hi @diegolima,

Account to your description, it sounds like a common measure formula calculate with multiple level aggregates.

If that is the case, I'd like to suggest you create a variable with summarize function to aggerated first level calculations, then you can add filter on the variable table to add filter condition on these aggregated results and use iterator function(e.g. sumx, averagex...) to apply the second level aggregations.

(e.g. aggregated values above 300)

Measure Totals, The Final Word
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors