Forum Discussion
Pivot data filtered by another table column
Perhaps as
FTE-CS := SUMX ( VALUES ( Quarters[Q] ), [ORE_CS per Hour] / [Somma di NUM_GG_STD] )where
ORE_CS per Hour := SUMX ( FactData, FactData[ORE_CS] / FactData[DayWorkHours] )and I added DaysWorkHours calculated columns to convert texts in HoursDays into numbers. If in HoursDays will be numbers that's not necessary.
Hi SergeiBaklan thanks a lot for feedback!!I attach the xlsx file, could you help me understand how to set the pivot?
Thanls in advance!
Fabio
Perhaps that could be
FTE new:=SUMX( VALUES( Quarters[Q] ), [Total ORI_CS] / [Day in Months Total] / 😎if I understood the logic correctly.
In above I used added explicit measures instead of implicit ones.
THANKS!!!!! it works fine!!
Now I have another issue: the formula calculates FTEs based on 8 hours per day. However, the number of hours/day to calculate the FTE is not always 8, but it changes according to the team.
To do this, I'he added the HourDays column in the FactData table populated with the hour/day of related team and I thought of using that in the formula you suggested, but it doesn't work. Is there any way to fix?I attach the xls file
Thanks in advance for suggestions
Fabio
Perhaps as
FTE-CS := SUMX ( VALUES ( Quarters[Q] ), [ORE_CS per Hour] / [Somma di NUM_GG_STD] )where
ORE_CS per Hour := SUMX ( FactData, FactData[ORE_CS] / FactData[DayWorkHours] )and I added DaysWorkHours calculated columns to convert texts in HoursDays into numbers. If in HoursDays will be numbers that's not necessary.