Loading

How to apply a filter on only one of the measures in the same worksheet

Publiceringsdatum: Apr 13, 2024
Uppgift
How can I apply a filter to only one of the measures without influencing other measures in the same sheet?
 
Steg
  1.  Create a calculated field below
    • Order_LOD: { FIXED [Region]:COUNT([Orders])}
  2. Drag the [Region] to the Columns shelf and then [Order(Count)] as well as the created [Order_LOD] to the Rows shelf.
  3.  Now use category in filter and this will be applied to the [Order(Count)] not [Order_LOD]. It is because Fixed level of detail expressions compute values without reference to the dimension in the view.
Please find the attached sample workbook.
Ytterligare resurser
Tableau's Order of Operations
Knowledge-artikelnummer

001470643

Bilagor

demo.twbx

1201 KB

 
Laddar
Salesforce Help | Article