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
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