Summarize Total

Question

Hi BI Gurus,&nbsp;i need a help for below..please checj&nbsp;i have a summarize table as below and i need to add and display count for same Extracted Title column.&nbsp;&nbsp;Ex: Total Column should be 7 +3=10 as the title is same.&nbsp;&nbsp;I do not want to change it to MAtrix table.SummaryMilestone = SUMMARIZE(&nbsp; &nbsp; filter(ODATA_LINKS, ODATA_LINKS[SourceType] &lt;&gt; BLANK() ),&nbsp; &nbsp; &nbsp; &nbsp; ODATA_LINKS[SourceTitle],ODATA_LINKS[ExtractedTitle],&nbsp;&nbsp; &nbsp; "Total", if(&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(count(ODATA_LINKS[ExtractedTitle]),NOT(ODATA_LINKS[targetState] IN {"Removed","Cancelled"}))=0,0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(count(ODATA_LINKS[ExtractedTitle]),NOT(ODATA_LINKS[targetState] IN {"Removed","Cancelled"}))),))

anonymous · Accepted Answer

Hi ak77&nbsp;,
Based on the description, try using the following DAX formula to create a table.
SummarizedTable = 
SUMMARIZE(
    ODATA_LINK,
    ODATA_LINK[ExtractedTitle],
    "Total", SUM(ODATA_LINK[Total])
)

The summarize table is shown below.

&nbsp;
Best Regards,
Wisdom Wu
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Summarize Total

2 Replies

Related content

Parameter in summarize

Don't Summarize....still summarizes...?

GroupBY and summarize

Merge Summarize Table

Use Copilot to summarize