Loading

Use Logic Statements to Filter an Individual Calculation

게시 일자: Feb 19, 2026
상세 설명
How to return only the measure associated with a specific member of a field, but not filter out the other members of that field. 
For example, if you want to return Sales only for the west region, but still access the rows associated with other regions. 
솔루션
Rather than placing [Region] on the filters shelf, create a calculation that will return only data for the West region, for example: 
IF [Region] = "West" THEN [Sales] END 
The above calculation will return only sales associated with the "West" region. 

Note: You can also use a CASE statement to achieve the same result. 
추가 자원
For more information on using IF and CASE statements, see Logical Functions. 

When filtering using the filters shelf, Tableau Desktop will filter all of the marks associated with the dimension member at the lowest level of aggregation. Using the IF/THEN statement method above will remove certain measure values from the view before the values are aggregated at the level of detail in the view.


Knowledge 기사 번호

001474078

 
로드 중
Salesforce Help | Article