Some of the options that were available for aggregating a field in PowerBi Desktop like:
Count (Not Blanks).
Are not there anymore. Any idea what happened? If I use almost the same model from a month ago it is there and if I use the one that was updated in last 3 weeks I am not able to use any of those on any field.
The only options that are available are:
New quick measure
Show items with no data
I must admit that using aggregation from that menu was extremly helpful and I would really like to get that back.
And just a quick update. If I use earlier version of that model, from a month ago, it looks like that:
@GMikula , if you right-click of measure, you will not get that option, as it is pre-aggregated, Also for test data type only max, min, first, last and count are applicable
These are not measures.
I do know that I won't get every aggregation possible on every data field. Depending on type it could be only some of them. But right now I do not get any as shown on 2 screenshots. On both of them it is the same field and on top I can't use any and on lower I do have that option. It is true for any value I use, regardless of type. The only difference I know - upper version is from last week, lower from a month ago.
Hi @GMikula ,
What version of powerbi is the in upper one?
I'm using this version and it works fine.
Are you using same pbix? Did you find same situation in other pbix?
I have this version:
Version: 2.82.5858.1161 64-bit (June 2020)
Strange thing is it works in other pbix, when for instance I create new or use the same file but from month ago (and way less developed than this one).
Funny thing is I found in this pbix some older tab where there actually is aggregation (FLIGHT_MIN is a simple numerical column) but when I try to change it I can't. Also if I remove it and use exactly the same field I can't make it again as average.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.