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...
  • amitchandak's avatar
    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