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

[diegolima]

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!

[Anonymous · Accepted solution]

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)

Reference link:

Measure Totals, The Final Word 
Regards,

Xiaoxin Sheng