Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
6 |