Forum Discussion

kekepania0529's avatar
kekepania0529
Helper I
4 years ago
Solved

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

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)
 

 

 

Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    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
)

     

     

2 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    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
)