Forum Discussion

BugmanJ's avatar
BugmanJ
Icon for Helper V rankHelper V
3 years ago
Solved

Using both ALL and ALLEXCEPT together?

Hello All, Simplistic table: YEAR COMPANY OrderNumber   [YEAR] is linked to a Calander Table which also has [YEAR] I have two slicers on the page, YEAR and COMPANY I am trying to ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    BugmanJ 
    Please try

     

    NumberofOrders =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[OrderNumber] ),
    ALLEXCEPT ( 'Table', 'Calendar'[Date] )
)

     

BugmanJ's avatar
BugmanJ
Icon for Helper V rankHelper V
3 years ago

tamerj1  / ValtteriN 

Slight variance on the above. In the Data above, lets say I have an extra coloumn called [TIMETOPRODUCE] but I want that to filter out orders less then 155

NumberofOrders =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[OrderNumber] ),
    ALLEXCEPT ( 'Table', 'Calendar'[Date] ),
    FILTER ( 'Table'[TimeToProduce]<155)
)


Doesnt work, any ideas?
J


  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    BugmanJ 

    NumberofOrders =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[OrderNumber] ),
    ALLEXCEPT ( 'Table', 'Calendar'[Date] ),
    'Table'[TimeToProduce] < 155
)