Forum Discussion

PKPK90's avatar
PKPK90
Helper I
2 years ago

Create table based on parameter value

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. DE...
PKPK90's avatar
PKPK90
Helper I
2 years ago

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