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
All respondents no brand (brand info) =
CALCULATE (
SUMX (
DISTINCT ( 'factBrandAwareness'[ObservationGUID] ),
FIRSTNONBLANK ( 'factBrandAwareness'[Weighted], 0 )
),
ALL ( 'dimBrandsByCountry'[Brand] )
)
Hi All
I am new to Power BI and DAX, I have the above code in an existing report I have picked up, would someone be able to break down what this doing on a generic level?
Thx!
Solved! Go to Solution.
@AGajree
The measure computes the total sum of the 'Weighted' column for all brands. It does this by accumulating the 'Weighted' values for each 'ObservationGUID' individually, considering only the first non-blank value for each 'ObservationGUID'.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@AGajree
The measure computes the total sum of the 'Weighted' column for all brands. It does this by accumulating the 'Weighted' values for each 'ObservationGUID' individually, considering only the first non-blank value for each 'ObservationGUID'.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 11 | |
| 10 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 19 | |
| 12 | |
| 11 |