CDF Formula:
CALCULATE(COUNT([KPI]), FILTER(ALLSELECTED([BINS]), [(BINS)]<= MAX([(BINS)])))
/ CALCULATE(COUNT([KPI]), ALL(BINS]))
Moving Average Formula:
AVERAGEX(DATESBETWEEN([Date] , MAX([Date]) - 4 , MAX([Date])), CALCULATE(AVERAGE([KPI])))
Example for 90perc:
PERCENTILE.INC(metric, 0.9)
Applying Conditional Formatting to Calculation Groups:
Format String for % = #,##0.00%
PowerBi PBIX Files
Excel Working Materials
Overview The Random Access procedure can be initiated in different situations depending on whether the network already knows the UE and whether dedicated resources can be assigned. Random Access Channel, or RACH, is used whenever the UE needs to establish or recover uplink synchronization with the network. In 5G, Random
Introduction After the UE completes system information acquisition, the next step is to determine whether the detected cell is suitable for camping. This process is called cell selection. During cell selection, the UE checks the available LTE cells and evaluates whether a cell satisfies the required coverage, quality, and access
Introduction When PDCCH utilization becomes high, the first question should not immediately be: Which PDCCH optimization feature should I enable? A better starting point is to understand what the PDCCH resources are actually being used for. PDCCH is involved in different procedures such as SIB1 transmission, Other System Information, Random
During SgNB Addition, there are three important timers that can directly affect the SgNB Addition Success Rate. The figure below shows where each timer starts and stops within the call flow. SgNB Addition Call Flow and Related Timers After the B1 Measurement Report is received, the MeNB starts the SgNB
Mohamed ELAdawi
Telecom Expert | 5G & 6G Trainer
