Forum Discussion
Problem with a DAX Query in DAX Studio
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 - 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.
Hi ,
If I understand correctly, you want to develope a paginated report and you are trying to generate the query in powerbi first then you will use that query in you paginated report dataset and the report will have parameter and based on that selection you want to switch the calculation.
I would recommend you to create a query in paginated dataset design mode and then customize it as per need. that would be simple.
would love help further if you face any difficulty.
Thanks,
Ankur04 thank you for anwser.
Yes, I would like to create a Pagnited Report.
Can you give me an example of how something like this could look with the Query Designer? I haven't worked with it much yet.