Forum Discussion

spaceman127's avatar
spaceman127
Super User
2 years ago
Solved

Problem with a DAX Query in DAX Studio

Hello Community, I have a problem with the following DAX query. Later I would like to use it in Power Bi Report Builder, but first I need to have a working query.   In principle, if ALL is selecte...
  • mark_endicott's avatar
    mark_endicott
    2 years ago

    spaceman127 - Are you attempting to create a calculated table?

     

    If so this will not work, because they cannot be created based on the input to filtering. Calculated tables are created at the point the model is refreshed, so do not accept inputs. 

     

    You are getting this error in DAX Studio because it is for testing the results of scalar values, and this query looks to be for a table. 

  • mark_endicott's avatar
    mark_endicott
    2 years ago

    spaceman127 - I do not have any experience with Paginated Reports, so I'll leave you in the hands of Ankur04 .

     

    As I have answered your orginal query, which was why the DAX would not work (and you are on a DAX part to the forum), I would be greatful if you can accept my answer as the solution (it helps for visibility for others). 

     

    There can be mulitple solutions to a query, so when Ankur04 helps you with the query you need, that can be accepted also. 

mark_endicott's avatar
mark_endicott
Super User
2 years ago

spaceman127 - Are you attempting to create a calculated table?

 

If so this will not work, because they cannot be created based on the input to filtering. Calculated tables are created at the point the model is refreshed, so do not accept inputs. 

 

You are getting this error in DAX Studio because it is for testing the results of scalar values, and this query looks to be for a table. 

spaceman127's avatar
spaceman127
Super User
2 years ago

mark_endicott  - Thank you for your anwser.

 

I have understood that it does not work.

 

What can I use instead to replace the calculated table?

I need this condition to check whether the variables __DS0FilterTable5 and __DS0FilterTable6 are filled with the value “ALL”.
Accordingly, it must then perform one or the other calculation.

 

Many greetz

  • mark_endicott's avatar
    mark_endicott
    Super User
    2 years ago

    spaceman127 - I do not have any experience with Paginated Reports, so I'll leave you in the hands of Ankur04 .

     

    As I have answered your orginal query, which was why the DAX would not work (and you are on a DAX part to the forum), I would be greatful if you can accept my answer as the solution (it helps for visibility for others). 

     

    There can be mulitple solutions to a query, so when Ankur04 helps you with the query you need, that can be accepted also.