기술 자료

When a Measure Filter Is Applied to Multiple Worksheets, Filtering Results Are Different for Each Worksheet


게시 날짜: 05 Mar 2024
마지막 수정 날짜: 06 Mar 2024

문제

When a measure filter is applied to multiple worksheets, filtering results are different for each worksheet.

For example, assume that you have the following worksheets. SUM(Sales) measure filter is applied to both worksheets.
 
User-added image
User-added image

When the filter condition is changed, data differences occur between the two worksheets. How can we avoid them? 

User-added image

환경

  • Tableau Desktop

해결 방법

Follow along in the sample packaged workbook found in the Attachments section to review the steps below.

1. Open a new worksheet, and add State/Province and Category to Rows.
2. Add SUM(Sales) to Text.
3. Open a new worksheet, and add Longitude (generated) to Columns, Latitude (generated) to Rows.
4. Add Country/RegionState/Province and Category to Detail.
5. Create a calculated and name it Sales (TOTAL) with the following formula:
TOTAL(SUM([Sales]))
6. Add Sales (TOTAL) to Color.
7. Right-click Sales (TOTAL) in Color and select Edit Table Calculation. Configure it as follows:
 User-added image
8. Add SUM(Sales) to Filters shelf.
9. Right-click SUM(Sales) in Filters shelf, and select Apply to Worksheets > Selected Worksheets and check the cross-tab worksheet above.
10. Open a new dashboard and place the two worksheets above. You can see that the subtotals in the cross-tab and the numbers in the map match, even if you change the filter condition.
 User-added image

원인

This issue has to do with the data granularity of the two worksheets. If you set up a measure filter across multiple worksheets, the measure values will be aggregated at the granularity of each worksheet.
이 문서로 문제가 해결되었습니까?