Build a table and filter it

[gtamir]

Hi, I have the folloing DAX function to build a table: 

RunningTotalByCreditCard = SUMMARIZECOLUMNS(creditcard[id_card], "TOTAL" , SUM(creditcard[sum]))

I'd like to add a filter so the table will show only records that have 3 in [Month] column, in Creditcard table

Thanks

[Fowmy]

@gtamir 

SUMMARIZECOLUMNS(
	creditcard[id_card], 
	"TOTAL" , SUM(creditcard[sum]), 
  	FILTER( creditcard , creditcard[Month] = 3 )
  )

[gtamir]

Thanks @Fowmy  I tryied that but it says:
Function SUMMARIZECOLUMNS expects a column name as argument number 4.

[Fowmy · Accepted solution]

@gtamir 

To create a table in the model, use the following:

SUMMARIZE(
	FILTER( creditcard , creditcard[Month] = 3 ),
	creditcard[id_card], 
	"TOTAL" , SUM(creditcard[sum])
  )

[gtamir]

Yes it works, thanks.