Count Average based on values from table visual

[alks_skla_f]

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?
I applied the same filters on data card as on table visual, but still doesn't work properly

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Praful_Potphode]

Hi @alks_skla_f ,

If the issue is not resolved,please provide clear snapshot of input/output.

Thanks and Regards,

Praful

[v-priyankata]

Hi @alks_skla_f 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@amitchandak @ryan_mayu Thanks for the inputs

I hope the information provided was helpful. If you still have questions, please share the pbix file & don't hesitate to reach out to the community.

[v-priyankata]

Hi @alks_skla_f 

Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.

[ryan_mayu]

@alks_skla_f 

not sure if this issue is fixed or not. I can't see the screenshot clearly. If the issue is still existing, could you pls share the pbix file?

[amitchandak · Accepted solution]

@alks_skla_f , Try with AverageX, seem like last time I used SUmx 

Averagex (summarize (cps_sfdc_cases_history, cps_sfdc_cases_history[Case Numer], cps_sfdc_cases_history[CraetedDate], cps_sfdc_cases_history[End Date]) , [measure_AverageFirstResolutionDateHours])