How to use measure inside Summarize Function

Hi, 

As far as I’m concerned, you can use the measures you created before in the newly created Summarize function in the <expression> parameter after the parameter <groupBy_columnName> and <name>, you can use the measure in your DAX formula like this:

Table F1 = SUMMARIZE (
SELECTCOLUMNS (
'Opportunity Snapshot',
"Source", 'Opportunity Snapshot'[Start of Quarter - Copy],
"Target", 'Opportunity Snapshot'[Flow one Result],
"Opportunity ID",'Opportunity Snapshot'[Opportunity_ID_18__c],
"Quarter",'Opportunity Snapshot'[Quarter]
),
[Source],
[Target],
[Opportunity ID],
[Quarter],
"Total", [Last ACV] )
)

You can change the measure formula based on your needs.

For more info, please refer to this link:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-use-measure-inside-Summarize-Function/td-p/2147727

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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