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 func...
General Comment
Need Help
Tips and Tricks
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.