Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

@Anonymous , Try like

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

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , Try like

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

tex628
Community Champion
Community Champion

In your Protocol table add the following calculated column:

Column = Related(Table Time[typeTime])


Then SUM() that column instead. 

Br,
J


Connect on LinkedIn
Anonymous
Not applicable

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

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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