In a Power BI visual using a DAX query, which type of analytics line is produced by the MEDIANX calculation?

In a Power BI visual using a DAX query, which type of analytics line is produced by the MEDIANX calculation?

• A. average line
• B. sum line
• C. median line
• D. trend line

Answer: (C)

MEDIANX returns the middle value when you evaluate an expression across all rows in a table. In a Power BI visual, an analytics line represents a single constant value across the x-axis. Since MEDIANX yields that central value, the line produced is a median line—a horizontal line at the median. It isn’t an average line (that would use AVERAGE/AVERAGEX), nor a sum line (SUM/SUMX), and it isn’t a trend line (a line of best fit).

MEDIANX returns the middle value when you evaluate an expression across all rows in a table. In a Power BI visual, an analytics line represents a single constant value across the x-axis. Since MEDIANX yields that central value, the line produced is a median line—a horizontal line at the median. It isn’t an average line (that would use AVERAGE/AVERAGEX), nor a sum line (SUM/SUMX), and it isn’t a trend line (a line of best fit).