Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate date between and count

I have data import from database, Orders and Sales this 2 table link with manyto1 relationship. 1 OrdersId can have many SalesID because the customers don't like to pay all of them in one time. Now I...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Create a measure like 1st one and display with order id from order

     


    if(isblank(count(sales[SalesID])),1,blank())

     

    or measure  like

    countx(values(Order[OrderID]) ,if(isblank(calculate(count(sales[SalesID]))),Order[OrderID],blank()))

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Create a measure like 1st one and display with order id from order

 


if(isblank(count(sales[SalesID])),1,blank())

 

or measure  like

countx(values(Order[OrderID]) ,if(isblank(calculate(count(sales[SalesID]))),Order[OrderID],blank()))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank You