I have this table attached, Tab MovFuncionarios, which has codnumber, codmov, datamov and value. This table has an inactive relation with dates (Tab Dates).
If i want to have the total for remunerations, i did this first:
T Value = CALCULATE(SUM( ‘Tab MovFuncionarios’[Value]),
USERELATIONSHIP( ‘Tab Dates’[Date], ‘Tab MovFuncionarios’[DataMov]))
Remunerations = CALCULATE( [T Value], FILTER( ‘Tab CodMov’, ‘Tab CodMov’[Categoria] = “Remunerações” ))
Of course i have another measures from this T Value measure and they’re working fine. All i want now is to now the average of the remunerations.
My report has a date and a cost center filter. My visual is by name and month-year.
I would like to see the average for each person and month-year and in another visual the average for the year and the average for each cost center.
Can you help?
Thanks a lot
Average.xlsx (121.7 KB)