https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-CODE-Understanding/m-p/3579655#M138051 <LI-CODE lang="markup">All respondents no brand (brand info) = CALCULATE ( SUMX ( DISTINCT ( 'factBrandAwareness'[ObservationGUID] ), FIRSTNONBLANK ( 'factBrandAwareness'[Weighted], 0 ) ), ALL ( 'dimBrandsByCountry'[Brand] ) )</LI-CODE><P><BR />Hi All<BR /><BR />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?<BR /><BR />Thx!</P> Tue, 12 Dec 2023 12:09:21 GMT AGajree 2023-12-12T12:09:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-CODE-Understanding/m-p/3579655#M138051 <LI-CODE lang="markup">All respondents no brand (brand info) = CALCULATE ( SUMX ( DISTINCT ( 'factBrandAwareness'[ObservationGUID] ), FIRSTNONBLANK ( 'factBrandAwareness'[Weighted], 0 ) ), ALL ( 'dimBrandsByCountry'[Brand] ) )</LI-CODE><P><BR />Hi All<BR /><BR />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?<BR /><BR />Thx!</P> Tue, 12 Dec 2023 12:09:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-CODE-Understanding/m-p/3579655#M138051 AGajree 2023-12-12T12:09:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-CODE-Understanding/m-p/3579676#M138052 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="659590" data-lia-user-login="AGajree" class="lia-mention lia-mention-user">AGajree</a>&nbsp;<BR /><BR />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'.</P> Tue, 12 Dec 2023 12:23:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-CODE-Understanding/m-p/3579676#M138052 Fowmy 2023-12-12T12:23:16Z