Forum Discussion
Solved
Help With SubTotal
Hello, I would like your support regarding this issue . The table below is a matrix , I created a mesure to have the % of diference between the previous week (Diff. to LW). Unfortunatelly the l...
amitchandak Sorry I forgot the measure .
M_NumberOfFlight = COUNTROWS('Rapport 1')M_LW NumberOfFlights =Var _SelectedWeek = SELECTEDVALUE('Rapport 1'[NUMERO SEMAINE])Var _SelectedHandler = SELECTEDVALUE('Rapport 1'[HANDLER])Var _SelectedOperator = SELECTEDVALUE('Rapport 1'[OPERATOR])Var _SelectedDir = SELECTEDVALUE('Rapport 1'[DIR])Var _SelectedYear = SELECTEDVALUE('Rapport 1'[MVT DATE + HR UTC].[Year])Var _res = CALCULATE( COUNTROWS('Rapport 1'),FILTER(ALL('Rapport 1'), 'Rapport 1'[NUMERO SEMAINE] = _SelectedWeek -1) , 'Rapport 1'[HANDLER] = _SelectedHandler,'Rapport 1'[OPERATOR] = _SelectedOperator, 'Rapport 1'[DIR] = _SelectedDir, 'Rapport 1'[MVT DATE + HR UTC].[Year] = _SelectedYear)RETURN _res% Diff. to LW =IF( ISBLANK( [M_LW NumberOfFlights] ),BLANK(),DIVIDE( [M_NumberOfFlight] - [M_LW NumberOfFlights] , [M_LW NumberOfFlights] , 0 ) )
Does anybody can help me ?