SSAS tabular Dax help

• SQL_Surfer

  SSCrazy Eights

  Points: 8320

  More actions

  February 20, 2019 at 7:43 pm

  #409525

  In my fact table, I have ordernumber and orderlinenumber column as below

  I need to show calculated measure in the report that shows Average line/ order.  

  In this example, there are 2 lines for ordernumber 1234 and 3 lines for Ordernumber 4444

  Ordernumber      OrderlineNumber
  1234                    10
  1234                     20
  4444                    10
  4444                     20
  4444                     30

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  February 20, 2019 at 9:11 pm

  #2022527

  Isn't it as simple as DIVIDE(COUNTROWS('OrderLineItems'),COUNTROWS('Orders')) ?