my if statement is not working dont know while
CountryOrder = IF(dim_SalesTerritory[SalesTerritoryRegion]="Australia", 1,
IF(dim_SalesTerritory[SalesTerritoryRegion]="Canada", 2,
IF(dim_SalesTerritory[SalesTerritoryRegion]="Germany", 3,
IF(dim_SalesTerritory[SalesTerritoryRegion]="France", 4,
IF(dim_SalesTerritory[SalesTerritoryRegion]="United Kingdom", 5,
IF(dim_SalesTerritory[SalesTerritoryRegion]="Northeast", 6,
IF(dim_SalesTerritory[SalesTerritoryRegion]="Central", 6,
IF(dim_SalesTerritory[SalesTerritoryRegion]="Southwest", 6,
IF(dim_SalesTerritory[SalesTerritoryRegion]="Southeast", 6,
IF(dim_SalesTerritory[SalesTerritoryRegion]="Northwest", 6,
BLANK()))))))))))
What error message do you get?
my countryorder table is giving me error
This statement needs to be used as a calculated column, please provide a screenshot
ok, i used it as measure