cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kaldorr Regular Visitor
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?

image.png

1 ACCEPTED SOLUTION

Accepted Solutions
rajendran Super Contributor
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
rajendran Super Contributor
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

MarcoRotta Regular Visitor
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
Kaldorr Regular Visitor
Regular Visitor

Re: SUMMARIZE Function

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

srikanthgunnam Regular Visitor
Regular Visitor

Re: SUMMARIZE Function

Hello,

 

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

CUST=
ADDCOLUMNS(
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",
IF ( [Premium] >=0 && [Premium]<100, "0-100",IF ( [Premium] >=100&& [Premium]<500, "100-500",IF ( [Premium] >=500 && [Premium]<1000, "500-1000M",IF ( [Premium] >=1000, "1000+" )))))
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.
 
Please help me out!!!!
Thanks in advance!!!!!

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 156 members 2,124 guests
Please welcome our newest community members: