Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have two tables which are linked by one column
for each colum(merged 1) I have one time
One the other table I have all merged 1, but sometimes there are many merged 1 which are similar.
when i do "related" function to put time from new table to timbratura, i have for the merged which are similar, the sum of time of this type of merged
How can I have a column without sum?
I would like a 0 on the second (or third in other case) similar merged 1 or if its possible, divide the time corresponding to merged 1 by the number of time that i can find the same merged 1
i dont know if am i clear, but i need help.
thanks 🙂
Solved! Go to Solution.
Try this
= DIVIDE ( RELATED ( NewTable[time] ), CALCULATE ( COUNTROWS ( timbratura ), ALLEXCEPT ( timbratura, timbratura[merged1] ) ) )
Try this
= DIVIDE ( RELATED ( NewTable[time] ), CALCULATE ( COUNTROWS ( timbratura ), ALLEXCEPT ( timbratura, timbratura[merged1] ) ) )