Minx returning blank row

[sbuster]

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)
        )
    }

[sbuster]

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...

[selimovd · Accepted solution]

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
Follow me: twitter.com/DenSelimovic

[sbuster]

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?