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 re...
Tips and Tricks
  • selimovd's avatar
    selimovd
    3 years ago

    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

selimovd's avatar
selimovd
Most Valuable Professional
3 years ago

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
3 years ago

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?