Hello, I have a table visual, which is filtered by using different options. The first filter is set on the right bar, where I filter "Status" and "New Value". The next filter is set in "Columns" section, where I filter First Closed Date by using Earliest keyword (case can be opened several times, I need to know only first closed date).I have a measure "First Resolution Date Business Hours". My task is to count average for this measure.To count average I am using this measure: measure_AverageFirstResolutionDateHours = DIVIDE( -- returns sum of values in measure FirstResolutionHours SUMX( cps_sfdc_cases_history, [measure_FirstResolutionHours_Optimized] ), COUNTROWS( FILTER( cps_sfdc_cases_history, NOT(ISBLANK([measure_FirstResolutionHours_Optimized])) ) ), 0 -- Default value if the denominator is 0 )After I decided to filter table in order to have a small sample which helps me check if average is correct. I am getting incorrect average. The answer is 2.06, but should be 2.12:The question is how I can count average of measure First Resolution Date Business Hours based on table visual, not table itself?

alks_skla_f , a new measure on top of your measure Sumx(summarize (cps_sfdc_cases_history, cps_sfdc_cases_history[Case Numer], cps_sfdc_cases_history[CraetedDate], cps_sfdc_cases_history[End Date]) , [measure_AverageFirstResolutionDateHours]) And try. In visual calculation you can try collapse all

Count Average based on values from table visual

Forum Discussion

Related content

Average and Moving Average

Count Average based on values from table visual

Values not averaging correctly based on date

Background color for Matrix visual for blank cells in Average values

Average value based on multiply samples per second, Average by minute