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.