Create table based on parameter value

Question

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

pkpk90 · Answer

I also tried this oneDEFINEvar Tabl1_=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATETABLE ( SUMMARIZECOLUMNS ( 'ItemBOMBlowout'[ProdCodeDesc] ) )var Tabl2_=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATETABLE (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUMMARIZECOLUMNS ( 'ItemBOMBlowout'[ProdCodeDesc] ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'TotalOrderedByCustomer'[CustomerName] = customer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;RETURN&nbsp;IF(customer = "*AllCustomers", Tabl1_, Tabl2_)&nbsp;&nbsp;&nbsp;&nbsp;The syntax for RETURN is incorrect

Forum Discussion

Create table based on parameter value

1 Reply

Related content

Create new table

Lakehouse Table Generate Create Table

Table Created with Field Parameters missing rows

Create rows from 2 tables

Parameter table dimensions - summarize