Forum Discussion

gtamir's avatar
gtamir
Post Patron
2 years ago
Solved

Build a table and filter it

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 s...
Need Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    gtamir 

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

    SUMMARIZE(
	FILTER( creditcard , creditcard[Month] = 3 ),
	creditcard[id_card], 
	"TOTAL" , SUM(creditcard[sum])
  )
Fowmy's avatar
Fowmy
Super User
2 years ago

gtamir 

SUMMARIZECOLUMNS(
	creditcard[id_card], 
	"TOTAL" , SUM(creditcard[sum]), 
  	FILTER( creditcard , creditcard[Month] = 3 )
  )
gtamir's avatar
gtamir
Post Patron
2 years ago

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

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    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's avatar
      gtamir
      Post Patron
      2 years ago

      Yes it works, thanks.