Forum Discussion

Pavithra_sarava's avatar
Pavithra_sarava
Regular Visitor
3 years ago
Solved

Need to find order without product without using calculated columns/tables

Hello All, I've 2 table in my report.   Order table: Order ID,Order name, value, Products,etc Order detail table: Order ID,Product name, Specification, etc   There's a relationship between Orde...
Need Help
  • lukiz84's avatar
    lukiz84
    3 years ago

    How is an order created if there are no products? 

     

    Try 

    OrdersWithoutProducts =
   CALCULATE(
      COUNT(Orders[Order ID]),
      NOT(Orders[Order ID] IN VALUES('Order detail'[Order ID]))
   )
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

If you have a one-to-many relationship from orders to order details then you could use

# orders no products =
SUMX ( 'orders', IF ( ISEMPTY ( RELATEDTABLE ( 'order details' ) ), 1 ) )
Pavithra_sarava's avatar
Pavithra_sarava
Regular Visitor
3 years ago

Hi,

sorry it's not working

  • lukiz84's avatar
    lukiz84
    Icon for Memorable Member rankMemorable Member
    3 years ago

    How is an order created if there are no products? 

     

    Try 

    OrdersWithoutProducts =
   CALCULATE(
      COUNT(Orders[Order ID]),
      NOT(Orders[Order ID] IN VALUES('Order detail'[Order ID]))
   )