Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Robert Lauga]

Hello,
I’m trying to study the SUMMARIZE function. So I found the example bellow, but I don’t know how to execute this code in Power BI or in Excel.
Thanks to the experts who can help a beginner!

EVALUATE

SUMMARIZE (

    Sales,

    Sales[Color],

    “Sales”, SUM ( Sales[Amount] ),

    “AllColorSales”,

    CALCULATE (

        SUM ( Sales[Amount] ), 

        ALL ( Sales[Color] )

     ),

    “AllSales”,

    CALCULATE (

        SUM ( Sales[Amount] ), 

        ALL ( Sales )

    )

)

——————————
Robert Lauga
——————————

[Audrey Abbey]

In Power BI, you would create a measure. 

Give it a name, then an equals sign, then your code goes after the equal sign. 
Remove the Evaluate command from the beginning. 
That is only used if you are running this command from SSMS or similar program.

Like this:

Summarize Example = 

SUMMARIZE (

    Sales,

    Sales[Color],

    “Sales”, SUM ( Sales[Amount] ),

    “AllColorSales”,

    CALCULATE (

        SUM ( Sales[Amount] ), 

        ALL ( Sales[Color] )

     ),

    “AllSales”,

    CALCULATE (

        SUM ( Sales[Amount] ), 

        ALL ( Sales )

    )

)

——————————
Audrey Abbey
SR. BI Developer/Analyst
LeapFrogBI
Portland OR
——————————
——————————————-

[Xavier Gobert]

Hi,

The outcome of the SUMMARIZE DAX function is a table so the result should be mapped to a table.

In Power BI, you create a new table by clicking on the button “New table” under the “Modeling” ribbon.
Then you just need to copy/paste Your DAX expression:
Table Name = Your DAX Expression

You will be able to see the results in the newly created table.

Enjoy

Xavier

——————————
Xavier Gobert
Head of Internal Development and BI
Tomra
Leuven
——————————
——————————————-