cancel
Showing results for
Did you mean:  Helper I

## Minx returning blank row

I'm trying to understand why the following DAX expression executed in DAX Studio returns a blank rows.  I don't see an explanation in the documentation about this.  I'd prefer not to have any rows returned vs a blank one.

DEFINE
table t = {(1)}
var _filter = filter(t,[Value]>1)
evaluate {
Calculate(
Minx(_filter,[Value]))
}

Furthermore, why this expression returns 1?  I thought Calculate applied the filter prior to the expression.

DEFINE
table t = {(1)}
var _filter = filter(t,[Value]>1)

evaluate {
Calculate(
Minx(t,[Value]),
filter(t,[Value]>1)
)
}

1 ACCEPTED SOLUTION  Super User

Hey @sbuster ,

as you figured out DAX Studio will show at least one row.

It is blank because the result returns a blank table.

Your second example returns also blank for me. Can you double check if it returns 1 for you?

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi

3 REPLIES 3  Helper I

I disccovered DAX Studio is returning a single row because I'm using the table constructor with no value, which will produce a single row with no value...  Super User

Hey @sbuster ,

as you figured out DAX Studio will show at least one row.

It is blank because the result returns a blank table.

Your second example returns also blank for me. Can you double check if it returns 1 for you?

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi  Helper I

The second example definitely returns 1 for me.  My assumption in the second example is that Calculate will call the filter function, which has argument t, first.  Then it will call Minx, which I do have as the first argument hte original table t.  How would the filtered table (the result of the filter funciton within Calculate) be passed into the Minx function?  