Forum Discussion

sbuster's avatar
sbuster
Helper I
3 years ago
Solved

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

  • 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

3 Replies

  • 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's avatar
      selimovd
      Most Valuable Professional

      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's avatar
        sbuster
        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?