Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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!
Solved! Go to 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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
216 | |
89 | |
76 | |
67 | |
60 |