Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I summed 14 columns of data using the SUMX function but instead of receiving individual values per row, I've recevied one big summed figure. Should I be doing something differently?
The formula I used is:
MeassureName = SUMX(TableName, TableName[column a] +TableName[column b] +TableName[column c] ...)
Solved! Go to Solution.
Hi,
add Calculate before SUMX to change to row context. e.g
CALCULATE(SUMX(TableName, TableName[column a] +TableName[column b] +TableName[column c] ...))
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
add Calculate before SUMX to change to row context. e.g
CALCULATE(SUMX(TableName, TableName[column a] +TableName[column b] +TableName[column c] ...))
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |