Aggregation Function not available Drag and Drop

[gia_sala]

Hi All, 

I have PowerBI Desktop version Versione: 2.105.923.0 64-bit (May 2022) 

In this week, I cannot to change a column field in the chart from dimension to a quick measure with aggregation function (COUNT). I have attached a screenshot. 

Thanks for your suppport.

[amitchandak]

@gia_sala , I can see that in My case. Hope this is not a live connection?

Try to create a measure count(Table[Column])  and use that 

[gia_sala]

Hi @amitchandak , this is not a live connection. 

Yes, the alternative solution will be to create a measure (as written by you) but I woul like to use fields with aggregation function for a quickly analysis. 

[Anonymous]

Hi @gia_sala ,

I have a test in PowerBI Desktop Version: 2.105.923.0 64-bit (May 2022) .

The count function in value field will appear and works well. Are two country columns the same column or from two different tables (related or unrelated).

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.