Create table based on parameter value

PKPK90 — Wed, 27 Sep 2023 08:05:33 GMT

Hi, I am trying to create table based on parameter value.

If parameter value is "*AllCustomers" then no filter to the table, but when Parameter value is different then filter by Parameter Value.

DEFINE

if (customer = "*AllCustomers",

CALCULATETABLE (

SUMMARIZECOLUMNS ( 'ItemBOMBlowout'[ProdCodeDesc]))

CALCULATETABLE (
SUMMARIZECOLUMNS ( 'ItemBOMBlowout'[ProdCodeDesc]),
'TotalOrderedByCustomer'[CustomerName] = customer))

but it does't work, probably the syntax is wrong

Re: Create table based on parameter value

PKPK90 — Wed, 27 Sep 2023 08:27:36 GMT

I also tried this one
DEFINE
var Tabl1_=
        CALCULATETABLE ( SUMMARIZECOLUMNS ( 'ItemBOMBlowout'[ProdCodeDesc] ) )
var Tabl2_=
        CALCULATETABLE (
            SUMMARIZECOLUMNS ( 'ItemBOMBlowout'[ProdCodeDesc] ),
            'TotalOrderedByCustomer'[CustomerName] = customer
        )


RETURN
IF(customer = "*AllCustomers", Tabl1_, Tabl2_)

The syntax for RETURN is incorrect

topic Re: Create table based on parameter value in DAX Commands and Tips

Create table based on parameter value

Re: Create table based on parameter value