Forum Discussion

Helper I

2 years ago

Return orders under specific value

Hi guys, I have two defined measures [Revenue] and [Orders]. Is there a way I can filter the [Orders] measure to return only those orders that are below certain [Revenue]? I can do some basic CAL...

Resident Rockstar

2 years ago

[Orders] =

Calculate (DISTINCTCOUNT('Transaction Lines'[Document Number]),

'Transaction Lines'[Type] IN {"Credit Memo", "Invoice"},[Revenue] <25000

)

Here I take 25000 for example you can take as you want

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Matej
Helper I
2 years ago
Hi,

Thanks for the reply. This was my initial thought as well but unfortunatelly it does not work. When added to the table I get the following error message: "A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

Any ideas of how to go around this?
- Dangar332
  Resident Rockstar
  2 years ago
  Hi, Matej
  
  These error come when we compare measure with condition without filter expression.
  
  Try below
  [Orders] =
  Calculate (DISTINCTCOUNT('Transaction Lines'[Document Number]),
  'Transaction Lines'[Type] IN {"Credit Memo", "Invoice"}, filter ('your table name',[Revenue] <25000))
  - Matej
    Helper I
    2 years ago
    Hi,
    
    Thanks for trying to help me. I have used the amended DAX but it seems like the last condition with [Revenue] < 25 (it is 25 in my case) is just ignored. The new measure returns same amount for each client in matrix as:
    CALCULATE(
    DISTINCTCOUNT('Transaction Lines'[Document Number]),
    'Transaction Lines'[Type] IN {"Credit Memo", "Invoice"}
    )