Power BI - Calculated Column = Calculated Column divided by Distinct Count Column

[kekepania0529]

I have 2 calculated columns, separately they work as intended: 

• GT/LB Shipped = IF(LEFT('Inbound Detail'[Product Group],3)="Non",'Inbound Detail'[Adjusted Net],'Inbound Detail'[Adjusted Net GT])
• Loads = CALCULATE(DISTINCTCOUNTNOBLANK('Inbound Detail'[Ticket #]))

I created a new calculated column to figure out the GT/LB per Load, but it returns the GT/LB Shipped, instead of the GT/LB per Load, like it's ignoring the Loads distinct count:

• GT/LB per Load = DIVIDE('Inbound Detail'[GT/LB Shipped],[Loads],0)

 

[AlexisOlson · Accepted solution]

Try using a measure instead of a calculated column since the calculated column will create an implicit measure that sums up each row of the column rather than the ratio that you want.

GT/LB per Load =
DIVIDE (
    SUM ( 'Inbound Detail'[GT/LB Shipped] ),
    SUM ( 'Inbound Detail'[Loads] ),
    0
)

[kekepania0529]

Thank you! That worked! 😎