cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Summarize value in a column with empty cells, filtered by other unique value from another column

Hello all,

I am searching in severall articles a solution for my issue.

I would like to display in a card the sum of points by week.

 Trip Points Week 1001 3 1 1001 3 1 1002 2 1002 2 1005 2 1 1005 2 1 1010 1 4

So i need the unique Trip numbers and the summarize of the points.

In some cases a trip has no points and stays empty.

 Trip Points Week 1001 3 1 1002 2 1005 2 1 1010 1 4

When i use the week filter in my dashboard, selecting week 1, the card must show me 5 Points.

The best working measure for me was this one, but didn't give the correct solution.

Measure = SUMX(SUMMARIZE(TblPoints, TblPoints[Trip], TblPoints[Points]), TblPoints)

What do i miss?

Gr,

1 ACCEPTED SOLUTION
Super User

@LogiFons

Use this measure:

``````Total Points =
SUMX(
VALUES( Table18[Trip]),
CALCULATE( MAX( Table18[Points] ) )
)
``````
Did I answer your question? Mark my post as a solution! and hit thumbs up
4 REPLIES 4
Community Support

I tested it with the data you gave me, tried the method you described, then selected week 1 in slicer, and got the result you wanted, I'm not sure if you did something else and got the wrong result. Can you provide more information? Please remove any sensitive data in advance.

Best Regards,

Community Support Team _Yuliax

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

Frequent Visitor

Hello Fowmy,

This has the same solution as my formula.

So i think there is something in my data sheet wrong.

I wil find out first.

Thank you!

Super User

@LogiFons

Use this measure:

``````Total Points =
SUMX(
VALUES( Table18[Trip]),
CALCULATE( MAX( Table18[Points] ) )
)
``````
Did I answer your question? Mark my post as a solution! and hit thumbs up
Frequent Visitor

Good morning,

I had some wromhg values in my table.

Now i am usinhg the measure of Fowny and thid is working.

Thank you both of your support.

Gr