Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

How to visualize Dax frames on Power BI?

I have the following measure:

Measure = DISTINCT(TABLE_A[item]) - DISTINCT(TABLE_B[item])

 

It is right, no error message appears, Although, when I try to put this measure on any type o visual I get the following error:

Error Message:
MdxScript(Model) (5, 32)

 

I known that is not possible to see a table, but how can I visualize this data, just for debbung purposes? Because I don't know what is the result of a DISTINCT function minus another DISTINCT function, so I want to see it. 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    9 years ago

    You can use DAX Studio to see what tables are returned by various functions. Nest them inside an EVALUATE() statement.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    DISTINCT returns a table, not a number. You can't do arithmetic on a table. I think you want DISTINCTCOUNT maybe?

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      No, I'm just using DISTINCT as a example, although tables does not support arithmetic, that measure does not  give me an error. The problem is that I want to visualize it for debbuging purposes.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        You can use DAX Studio to see what tables are returned by various functions. Nest them inside an EVALUATE() statement.