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 show only records that have 3 in [Month] column, in Creditcard table

 

Thanks

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])
  )

4 Replies

  • 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])
  )