Forum Discussion

gia_sala's avatar
gia_sala
Regular Visitor
4 years ago

Aggregation Function not available Drag and Drop

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.

 

 

 

 

General Comment
Need Help
Tips and Tricks

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      gia_sala
      Regular Visitor
      4 years ago

      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's avatar
        Anonymous
        Not applicable
        4 years ago

        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.