Skip to main content
cancel
Showing results for 
Search instead 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

Reply
LogiFons
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.

 

TripPointsWeek
100131
100131
1002 2
1002 2
100521
100521
101014

 

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

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

 

TripPointsWeek
100131
1002 2
100521
101014

 

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
Fowmy
Super User
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


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

4 REPLIES 4
v-xuxinyi-msft
Community Support
Community Support

Hi @LogiFons 

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.

vxuxinyimsft_0-1702432227917.png

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.

LogiFons
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!

Fowmy
Super User
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


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors