Forum Discussion

alks_skla_f's avatar
alks_skla_f
Helper II
9 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" se...
Need Help
  • amitchandak's avatar
    amitchandak
    9 months ago

    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 

amitchandak's avatar
amitchandak
Super User
9 months ago

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 

  • alks_skla_f's avatar
    alks_skla_f
    Helper II
    9 months ago

    Unfortunately, it doesn't work. I accepted this as a solution by mistake

    • amitchandak's avatar
      amitchandak
      Super User
      9 months ago

      alks_skla_f , Try Averagex 

       

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