Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 image
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.
I can not bring the SLA_TEORIC field to the formula
Solved! Go to Solution.
I think this might need to be:
New Column = DIVIDE( GTI_POWERBI[TeimpoEfectivoSolucion], SUMX (RELATEDTABLE(BD_SLA),BD_SLA[SLA_TORICO), 0)
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)
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.
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?
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |