cancel
Showing results for
Did you mean:
Highlighted
srikanthgunnam Regular Visitor

Hello, I am using a SUMX function in one of my calculation. It is completely degrading the performance of visual. Here is my calculation:

Dummy =
CALCULATE(
SUMX(DISTINCT(TBL[Account Name]),[Count])
)
In the above calculation count is a measure, which was calculated as follows:
CALCULATE(
DISTINCTCOUNT(TBL[SaleType])
)
Can you please suggest me a way to improve the performance?
1 ACCEPTED SOLUTION

Accepted Solutions Super User

Re: SUMX Function Degrading the Performance

SUMX is iterator, that's why it's so much slower

`CountUnique = COUNTROWS(SUMMARIZE(TBL,TBL[Account Name],TBL[SaleType]))`
4 REPLIES 4 Super User

Re: SUMX Function Degrading the Performance

SUMX is iterator, that's why it's so much slower

`CountUnique = COUNTROWS(SUMMARIZE(TBL,TBL[Account Name],TBL[SaleType]))`
srikanthgunnam Regular Visitor

Re: SUMX Function Degrading the Performance

Thank you so much!!! Worked like a charm

srikanthgunnam Regular Visitor

Re: SUMX Function Degrading the Performance

Hello @Stachu,

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. If you need help with that I'd suggest creating a new thread with samples from both tables, and marking this one as solved - helps to avoid the clutter on the forum, and may help other user with similar SUMX problems 