Forum Discussion

Baarathi88's avatar
Baarathi88
Icon for Helper III rankHelper III
6 years ago
Solved

Restrict based on summation

Is there a way to Count Distinct Order with Sales above 300.   I tried this expression but getting wrong result.  Order Count = CALCULATE(DISTINCTCOUNT(Sheet1[OrderID]),FILTER(Sheet1,Sum(Sheet1[S...
Need Help
Show and Tell
Tips and Tricks
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    Baarathi88 

    It's all about context.  Give this a try:

    Order Count = 
CALCULATE(
    DISTINCTCOUNT( Sheet1[OrderID] ),
    FILTER ( 
        VALUES(Sheet1[OrderID]),
        CALCULATE( SUM ( Sheet1[Sales] ) > 300 )
    )
)
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
6 years ago

Baarathi88 

It's all about context.  Give this a try:

Order Count = 
CALCULATE(
    DISTINCTCOUNT( Sheet1[OrderID] ),
    FILTER ( 
        VALUES(Sheet1[OrderID]),
        CALCULATE( SUM ( Sheet1[Sales] ) > 300 )
    )
)