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]) ...
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
)

     

     

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
)

 

 

  • kekepania0529's avatar
    kekepania0529
    Helper I
    4 years ago

    Thank you! That worked! 😎