Tableau Desktop Specialist — Question 111

A Data Analyst applied a dimension filter to a worksheet with FIXED Level of Detail (LOD) calculations.

How does this filter affect the worksheet?

Answer options

• A. The dimension filter alters the data displayed in the worksheet along with the FIXED LOD calculation.
• B. The dimension filter alters the data displayed in the worksheet before computing the FIXED LOD calculation.
• C. The dimension filter is carried out first before computing the FIXED LOD calculation.
• D. The dimension filter alters the data displayed in the worksheet but does not influence the FIXED LOD calculation.

Correct answer: D

Explanation

The correct answer is D because FIXED LOD calculations are independent of dimension filters; thus, while the filter changes the visible data, it does not impact the results of the FIXED LOD calculations. Options A, B, and C incorrectly imply that the dimension filter influences or precedes the FIXED LOD calculations, which is not the case.