Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I can't figure out why SUMX won't return ANY value. I feel like I must be overlooking something very simple. Any hints??
Solved! Go to Solution.
The issue was a filter that was causing side effects. Poor report design.
The issue was a filter that was causing side effects. Poor report design.
@delish1204 So [Formatted Report Data Set Line Text] is a measure?
No it is not a measure. It's a column in the table, hence the SUMX.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 27 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 73 | |
| 66 | |
| 65 |