cancel
Showing results for
Did you mean:
Regular Visitor

## SUMMARIZE Function

Halo People

So the summarize function dont seem to work as expected, see below. The error does not make sense, since the expression is merely a sum(table[tonnes column) and I just saw someone in a youtube video using it the exact same way?

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: SUMMARIZE Function

I think you are trying to create this as Measure, Navigate to Modelling -> New Table, ad use the formula there.

Thanks

Raj

4 REPLIES 4
Super Contributor

## Re: SUMMARIZE Function

I think you are trying to create this as Measure, Navigate to Modelling -> New Table, ad use the formula there.

Thanks

Raj

Regular Visitor

## Re: SUMMARIZE Function

The SUMMARIZE command will create a new table. It really seems you're trying to use it in a measure, which will not work. So, first make sure you are at the "Data view" when you use it (not on the report view). I'd also make sure that your columns/fields, such as "Tonnes & Carats" are properly reference, usually in the "Table[Field]" format.

Regards.

Highlighted
Regular Visitor

## Re: SUMMARIZE Function

Aha, I feel silly thank you very much. This makes a lot of sense

Regular Visitor

## Re: SUMMARIZE Function

Hello,

I have two tables like TBL and CUST. I have created the CUST table using the DAX.

CUST=
SUMMARIZE(FILTER(TBL,NOT(TBL[Account])=BLANK()),TBL[Account ],
"Sale",CALCULATE(SUM(TBL[Sale Amount]),FILTER(TBL,TBL[Ind]="Yes"),FILTER(TBL,TBL[Ind2]="Yes" && NOT(TBL[Code]) IN {"4"} ))
),
"Grp",
Now, I have created a relationship between those two tables using "Account" column and created a Cust Grp column in TBL using Related(CUST[Grp]). I want build a customer count based on grouping.
Problem:
Counts were fine when there were no filters applied but when I apply a filter on TBL tables Sale amount in CUST table is not filtering(I selected filtering as Both direction). As a result, counts in the group are not being calculated properly.
For example, if I filter country in TBL to the "USA" the premium in the CUST table is not changing.

Announcements

Power BI Super User, Greg Deckler, explains

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 156 members 2,124 guests
Recent signins: