Sum of a measure

[Lucy_Ramirez]

Hello team

I need help with a formula that will help me sum a measurement.

Use the following formula and it came out correct.

Impact = SUMX(values(KARDEX[ID Art]),[Impact])

But if I remove the "Article ID" field the result changes and I need the result to be -0.71% and not 0.99%

Any help helps.

Thanks a lot

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Anonymous]

Hi @Lucy_Ramirez ,

Please try this measure:

Measure =

SUMX(

    SUMMARIZE(

        'Table',

        'Table'[RowName],

        'Table'[ColumnName],

        "total",[Impact]//your measure

    ),

    [total]

)

Please refer to the following document for more information.

How to Make Measures Total Correctly in Power BI Tables - ArcherPoint

Calculating the SUM of Calculated Measure - Microsoft Power BI Community

Power BI Measure SUM - Complete tutorial - EnjoySharePoint

Dealing with Measure Totals - Microsoft Power BI Community

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Greg_Deckler]

@Lucy_Ramirez This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.