Forum Discussion
Solved
Filter on measure in direct query does not work
Hi all, I am trying to create a measure that contains a filter on another measure. I'm working in direct query mode (unfortunately the data comes in via API so I cannot work via Import mode), so...
Hi Fowmy
I found a solution. This measure works:
CALCULATE (DISTINCTCOUNT('Order'[order_number]), FILTER('Order',[DLT pick up status]="Order zelfde dag gepickt"))(I did not use the filter function before)Many thanks for your help!
HI Fowmy , I am indeed creating a measure, not a column (not possible in DQ mode)..
I've copied the measure from your first post but get the same error:
Many thanks for all your help. Much appreciated!
Hi Fowmy
I found a solution. This measure works:
CALCULATE (
DISTINCTCOUNT('Order'[order_number]), FILTER('Order',[DLT pick up status]="Order zelfde dag gepickt")
)
(I did not use the filter function before)
Many thanks for your help!