cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Martyna_
Helper III
Helper III

Doesn't count the SUM.

Hello,

I have two tables and there is a relationship between them.

Table Procotols:

EmployeeProtocol type
JohnA
TimB
JohnC
JohnA

 

Table Time:

Protocol typeTime
A0,5
B0,5
C2

 

I have relationship between them by Protocol type.

I'm trying calculate SUM or TOTAL - it's not working or show bad value (non-summed values)..

For example, I need to see this result:

powerbi.png

The time type is set to decimal value.

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@Martyna_ , Try like

sumx(Procotols, related(Time[Time]))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

3 REPLIES 3
amitchandak
Super User IV
Super User IV

@Martyna_ , Try like

sumx(Procotols, related(Time[Time]))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

tex628
Super User II
Super User II

In your Protocol table add the following calculated column:

Column = Related(Table Time[typeTime])


Then SUM() that column instead. 

Br,
J


Connect on LinkedIn
larsbb
Helper II
Helper II

Did you create a measure that uses the SUM() function? If so, can you share a screenshot of this formula? 

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors