Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to 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])
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
SUMMARIZECOLUMNS(
creditcard[id_card],
"TOTAL" , SUM(creditcard[sum]),
FILTER( creditcard , creditcard[Month] = 3 )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks @Fowmy I tryied that but it says:
Function SUMMARIZECOLUMNS expects a column name as argument number 4.
@gtamir
To create a table in the model, use the following:
SUMMARIZE(
FILTER( creditcard , creditcard[Month] = 3 ),
creditcard[id_card],
"TOTAL" , SUM(creditcard[sum])
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Yes it works, thanks.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
58 | |
57 |