Forum Discussion

RvdHeijden's avatar
RvdHeijden
Icon for Post Prodigy rankPost Prodigy
8 years ago
Solved

Combining 2 tables and Summarize

Goodday,   Im hoping someone can help me out on this one. I have a table where ALL the incidents are registered and categorized based on 'Soort Schade' and a few extra colums.   What i want to d...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi RvdHeijden,

     

    In this scenario, you can adjust the formula like below. :smileyhappy:

    New Table = 
SUMMARIZE (
    Data,
    Data[Infrastructuur],
    "Civiel (BIS)", COUNTROWS ( FILTER ( Data, Data[TeamType] = "Civiel (BIS)" ) ),
    "Civiel (Tuin)", COUNTROWS ( FILTER ( Data, Data[TeamType] = "Civiel (Tuin)" ) )
)

     

    Regards

Datatouille's avatar
Datatouille
Icon for Solution Sage rankSolution Sage
8 years ago

So basically you want to summarize this table :

Damage                 Infrastructuur

1.                             Electric

2.                             Gas

3.                             Water

4.                             Water

 

Let's assume the table above is called 'Data'.

 

If the 'Data' table comes from a DAX query, then it won't be available in Power Query and you need to use a DAX method:

 

Use this DAX query to create your desired table ('Modeling' tab and then 'New Table' in Power BI Desktop):

New Table = ADDCOLUMNS( SUMMARIZE(Data;Data[Infrastructuur]);"Number Of Tickets"; CALCULATE(COUNTROWS(Data) ))

if your 'Data' table is available in Power Query, you can use a the 'Group by' feature and chose count rows in the 'operation' section.