Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Group By in Power Bi

Hi, When we do the group by in Power Bi Using DAX or using Group By option from Power Query. is Power Bi creating the Virtual table?    
General Comment
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for the reply Tom. I know the difference between both.

When we use the DAX for the group by then Power Bi creates a separate table. Is It possible to handle this using calculate measure or column?

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
5 years ago

Hey Anonymous ,

 

I have to admit that I have no idea what you are trying to achieve. For this reason, please provide more information and describe your requirement in more detail..

 

Regards,

Tom

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hey Tom,

     

    I have achieved functionality using Summarize function but My question is when we use Group by, Summarize or SummarizeColumn DAX functions then In Power BI, it is creating an extra table.

     

    Can we achieve this using measure or calculate column which will not create an extra table.

     

    • TomMartens's avatar
      TomMartens
      Icon for Super User rankSuper User
      5 years ago

      Hey Anonymous ,

       

      still, your requirement is not clear, I assume I'm slow today.

       

      I recommend following this module about data modeling: https://docs.microsoft.com/en-us/learn/paths/model-power-bi/

      Grouping data (filtering data) is one of the core capabilities of the Power BI data model based on the SQL Server Analysis Services Tabular engine.

       

      You can create tables that help to filter/aggregate/group your data and write a measure, if there is more to the aggregation of numeric values then the available aggregation functions.

       

      Regards,

      Tom