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

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

Reply
diegolima
Helper III
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:

diegolima_0-1675256411696.png

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

 

diegolima_1-1675256448185.png

 

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
v-shex-msft
Community Support
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)

Reference link:

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.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
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)

Reference link:

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.