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
jbolivar
Frequent Visitor

Field in related tables

Good morning friends.

It's the first time this happens to me because I'm learning.

I have 2 related tables as you can see in the following imagetablasrelacionadas.JPG

 

 

 

In the GTI-POWERBI table, I need a calculated column with the result of dividing the TeimpoEfectivoSolucion divided by the SLA_TORICO field of the BD_SLA table.

CamposACalcular.JPG

 

I can not bring the SLA_TEORIC field to the formula

1 ACCEPTED SOLUTION

I think this might need to be:

 

New Column =
   DIVIDE(
      GTI_POWERBI[TeimpoEfectivoSolucion],
      SUMX (RELATEDTABLE(BD_SLA),BD_SLA[SLA_TORICO),
      0)

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

5 REPLIES 5
pawel1
Skilled Sharer
Skilled Sharer

try this:

 

New Column =

   DIVIDE(

      GTI_POWERBI[TeimpoEfectivoSolucion],

      SUM (BD_SLA[SLA_TORICO]),

      0)

 

This solution worked but it did not give me the expected results.

Thank you.

I think this might need to be:

 

New Column =
   DIVIDE(
      GTI_POWERBI[TeimpoEfectivoSolucion],
      SUMX (RELATEDTABLE(BD_SLA),BD_SLA[SLA_TORICO),
      0)

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

This solution worked and gave me the expected results.

 

However, I also made this formula and it also worked for me.

 

GTI_POWERBI[TiempoEfectivoSolucion] / CALCULATE(SUM(BD_SLA[SLA_TEORICO]);BD_SLA[SLA_TEORICO]>0)

 

Thank you.

jthomson
Solution Sage
Solution Sage

From the looks of things you've got a one to many relationship - how would it know which of the SLA results to bring in?

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.