Forum Discussion

alks_skla_f's avatar
alks_skla_f
Helper II
8 months ago
Solved

Count Average based on values from table visual

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

  • 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])

6 Replies

  • 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])

  • 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?

  • v-priyankata's avatar
    v-priyankata
    Community Support

    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's avatar
      v-priyankata
      Community Support

      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.