Menu showing Count Distinct count etc has disappeared

This is from a previous version of Power Bi (first visual)....but in the April version this menu has changed for some reason and First, Last, Count, Distinct, etc...are all gone.  What the heck??

 

texmexdragon2_0-1684959818832.png     

 

 

texmexdragon2_1-1684959937248.png

 

 

Investigating
Comments
avatar user
Anonymous
Not applicable

Hi @Anonymous ,

 

I am not able to reproduce your problem, please check my test result below:

vxiaoyanmsft_0-1684991743873.png

 

 

My test version:2.116.966.0 64-bit (April 2023)

 

Best regards.
Community Support Team_ Caitlyn

 

avatar user
Anonymous
Not applicable

@Anonymous     I have updated to May and I have the same issue.   

 

I should note that this issue seems to a particular pbix file that is a dataset file, however, all of the other reports that connect to this dataset have the same issue.   Here is another example, you can see below that these numeric values are missing all of the other options (sum, average, minimum, maximum, etc). 

It seems to be some strange corruption issue where that section of the menu has just completely disappeared and it effects the pbix file used as the dataset as well as any report files that are connecting to it.   I have many other such datasets/reports with the same set up, using the same dataflows, and none of them have this issue.   Luckily, I save backups about every two weeks, and my prior backup does not have this issue so I will have recreate any updates I made recently and make my backup file my primary file now.    But yes, I doubt very seriously it can be recreated as it seems like a very unique bug.  

 

 

texmexdragon2_0-1685019331530.png

This is what the menu fields should be showing - from a different file: 

 

texmexdragon2_1-1685019473081.png

 

 

andrew_ll
Microsoft Employee

I met the same issue.

One day when I open the file I edit two days ago, the menu of count, average,,,  disappeared.

andrew_ll_0-1722904865103.png

 

 

andrew_ll
Microsoft Employee

@Anonymous The solution is to disable the "Discourage implicit measure" in model properties. Then the menu come back.