Forum Discussion

gtamir's avatar
gtamir
Icon for Post Patron rankPost 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])
  )
gtamir's avatar
gtamir
Icon for Post Patron rankPost 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
Icon for Super User rankSuper 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
    Icon for Post Patron rankPost Patron
    2 years ago

    Yes it works, thanks.