Unit Test Writer | DAX

Unit Tests for Product Filtering by Color in Different Categories

This DAX script includes unit tests for filtering products by color (red) in clothing, accessories, and footwear categories. It utilizes SWITCH function to categorize products.


Empty image or helper icon

Prompt

EVALUATE
FILTER(
    ADDCOLUMNS(
        'Product',
        "Category",
        SWITCH(
            TRUE(),
            RELATED('ProductCategory'[ProductCategoryName]) = "Clothing", "Apparel",
            RELATED('ProductCategory'[ProductCategoryName]) = "Accessories", "Accessory",
            RELATED('ProductCategory'[ProductCategoryName]) = "Footwear", "Shoes",
            "Other"
        )
    ),
    'Product'[Color] = "Red"
)

Answer

# Unit Test 1: Test for filtering Products with Color Red in Clothing Category
EVALUATE
VAR FilteredProducts =
    FILTER(
        ADDCOLUMNS(
            'Product',
            "Category",
            SWITCH(
                TRUE(),
                RELATED('ProductCategory'[ProductCategoryName]) = "Clothing", "Apparel",
                RELATED('ProductCategory'[ProductCategoryName]) = "Accessories", "Accessory",
                RELATED('ProductCategory'[ProductCategoryName]) = "Footwear", "Shoes",
                "Other"
            )
        ),
        'Product'[Color] = "Red"
    )
RETURN
    COUNTROWS(FilteredProducts) > 0

# Unit Test 2: Test for filtering Products with Color Red in Accessories Category
EVALUATE
VAR FilteredProducts =
    FILTER(
        ADDCOLUMNS(
            'Product',
            "Category",
            SWITCH(
                TRUE(),
                RELATED('ProductCategory'[ProductCategoryName]) = "Clothing", "Apparel",
                RELATED('ProductCategory'[ProductCategoryName]) = "Accessories", "Accessory",
                RELATED('ProductCategory'[ProductCategoryName]) = "Footwear", "Shoes",
                "Other"
            )
        ),
        'Product'[Color] = "Red"
    )
RETURN
    COUNTROWS(FilteredProducts) > 0

# Unit Test 3: Test for filtering Products with Color Red in Footwear Category
EVALUATE
VAR FilteredProducts =
    FILTER(
        ADDCOLUMNS(
            'Product',
            "Category",
            SWITCH(
                TRUE(),
                RELATED('ProductCategory'[ProductCategoryName]) = "Clothing", "Apparel",
                RELATED('ProductCategory'[ProductCategoryName]) = "Accessories", "Accessory",
                RELATED('ProductCategory'[ProductCategoryName]) = "Footwear", "Shoes",
                "Other"
            )
        ),
        'Product'[Color] = "Red"
    )
RETURN
    COUNTROWS(FilteredProducts) > 0

Create your Thread using our flexible tools, share it with friends and colleagues.

Your current query will become the main foundation for the thread, which you can expand with other tools presented on our platform. We will help you choose tools so that your thread is structured and logically built.

Description

This DAX script includes unit tests for filtering products by color (red) in clothing, accessories, and footwear categories. It utilizes SWITCH function to categorize products.

More Unit Test Writers
Apache Flink Unit Test WriterApache Pig Unit Test WriterAzure Data Factory Unit Test WriterC/C++ Unit Test WriterCouchDB Unit Test WriterDAX Unit Test WriterExcel Unit Test WriterFirebase Unit Test WriterGoogle BigQuery Unit Test WriterGoogle Sheets Unit Test WriterGraphQL Unit Test WriterHive Unit Test WriterJava Unit Test WriterJavaScript Unit Test WriterJulia Unit Test WriterLua Unit Test WriterM (Power Query) Unit Test WriterMATLAB Unit Test WriterMongoDB Unit Test WriterOracle Unit Test WriterPostgreSQL Unit Test WriterPower BI Unit Test WriterPython Unit Test WriterR Unit Test WriterRedis Unit Test WriterRegex Unit Test WriterRuby Unit Test WriterSAS Unit Test WriterScala Unit Test WriterShell Unit Test WriterSPSS Unit Test WriterSQL Unit Test WriterSQLite Unit Test WriterStata Unit Test WriterTableau Unit Test WriterVBA Unit Test Writer