magritton
6/8/2014 - 10:46 AM
Dax role based filter. This shows a complex filter
Dax role based filter. This shows a complex filter
=LEFT([Company_Code])="2" && ([Year]=YEAR(TODAY())-1 || [Year]=YEAR(TODAY())) && [Sales Region] <> "LATIN AMERICA-L BARRIGA"
&& [Sales Region] <> "ASIA PACIFIC-RICHARD CHEN" && [Sales Region] <> "ASIA PACIFIC-RICHARD CHEN" && [SHIP_TO_COUNTRY] <> "PL"
&& [COMPANY_CODE] <> "210" && [COMPANY_CODE] <> "220" && [COMPANY_CODE] <> "230" && [COMPANY_CODE] <> "280"
&& [DOVER_COMPANY] = "N" && ([SHIP_TO_COUNTRY] = "CA" || [SHIP_TO_COUNTRY] = "US") && [ITEM_FAMILY] <> "CLEANENERGY FUELING PRODUCTS"