All measures not showing up in Power BI Report Builder
I am creating Paginated Report based on PBI Dataset. I selected Dataset as Data Source, but while creating Dataset using Query Designer I get notification under "Measures" category: More Measures exist than can be shown.
And many measures needed for my report are not in my measure folder. How do I access full list of measures?
I tried adding them manually in querry Expression, but as soon as I add measures that don't show up in querry designer, I get this error:
I don't think it was syntax error, because I could not add even one column, and I copied syntax from existing columns. But I may have edited querry in the wrong form, as I'm not used to editing it manually.
The way I dealt with this issue was by creating new dataset in Power BI, based on data of existing Dataset. There I creaded new measure table with dublicates of all the measures needed for my Paginated report.
Then I used this dataset as source for my Paginated report.
This probably was not the best solution, but it was the fastest way I could deal with this.
I don't think it was syntax error, because I could not add even one column, and I copied syntax from existing columns.
If you were using the SummarizeColumns() function measures use a different syntax to columns so it is most likely your issue was related to a syntax error, but without seeing the text for your query it's impossible to know for sure.