Forum Discussion

AGajree's avatar
AGajree
Regular Visitor
2 years ago
Solved

DAX CODE Understanding

All respondents no brand (brand info) = CALCULATE ( SUMX ( DISTINCT ( 'factBrandAwareness'[ObservationGUID] ), FIRSTNONBLANK ( 'factBrandAwareness'[Weighted], 0 ) ), ALL ...
Need Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    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'.

Fowmy's avatar
Fowmy
Super User
2 years ago

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'.