Dennes Torres sorts out an issue:
DAX Query View was created some time ago and it was a great tool to run DAX inside Power BI environment.
However, testing a measure in DAX Query View may not be something so obvious. While the measure in a report obeys to the filter context and most of times results in a single value, the filter context doesn’t exist in Query View and the execution needs to return a table.
In this way, a simple copy/past of the measure in DAX Query View will not run. The measure needs to be adapted to be tested.
Let’s analyze one sample case to discover how this happens.
Click through for the answer.