Forum Discussion
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...
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
Unfortunately, it doesn't work. I accepted this as a solution by mistake
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])