Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Correct SUMMARIZATION in a SUMMARIZE TABLE

Hi there, I need to achieve something and I know it's possible, only I don't know how and have spent too many days struggling with this. It will take me a bit to explain, so thanks in advance x your...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous Maybe because in this PBIX I get identical results in the summarized table and the table visual. See PBIX below.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

This is an example of the data:

 

PROJECTTASKTEAMPHASEPlanned Hours
89685Design Check CCBPhase 0143
89685Prod Detail CCBPhase 0942
89685Prod Detail CCBPhase 0840
89685Prod Detail VVDPhase 0935
89685Prod Detail VVDPhase 0425
89685Prod Detail VVDPhase 0525
89685Review CCBPhase 0824
89685Prod Check TrimCCBPhase 0821
89685Prod Detail VVDPhase 0120
89685Prod Detail VVDPhase 0220
89685Prod Detail VVDPhase 0420
89685Prod Detail VVDPhase 0520
89685Prod Check CCBPhase 0116
89685Prod Check CCBPhase 0216
89685Prod Check CCBPhase 0316
89685Prod Check CCBPhase 0416
89685Prod Check CCBPhase 0516
89685Prod Detail VVDPhase 0111
89685Prod Detail VVDPhase 0211
89685Prod Detail VVDPhase 0311
89685Prod Detail VVDPhase 0411
89685Prod Detail VVDPhase 0511
89685DesignCCBPhase 018
89685Prod Detail Corrections VVDPhase 038
89685Drawings ReviewCCBPhase 014
89685Drawings ReviewCCBPhase 024
89685Drawings ReviewCCBPhase 044
89685Drawings ReviewCCBPhase 054
89685Prod DetailCCBPhase 094
89685Drawings ReviewCCBPhase 031
89685Drawings ReviewCCBPhase 090.5
89685Drawings ReviewCCBPhase 090.5
89685DrawingsCCBPhase 090.5
89685DrawingsCCBPhase 010.5
89685DrawingsCCBPhase 020.5
89685DrawingsCCBPhase 030.5
89685DrawingsCCBPhase 040.5
89685DrawingsCCBPhase 050.5
89685Drawings ReviewCCBPhase 010.06
89685Drawings ReviewCCBPhase 020.06
89685Drawings ReviewCCBPhase 030.06
89685Drawings ReviewCCBPhase 040.06
89685Drawings ReviewCCBPhase 050.06
89685Design Release to DraftingCCBPhase 010
89685IFC Drawings MailedCCBPhase 010
89685IFC Drawings MailedCCBPhase 020
89685IFC Drawings MailedCCBPhase 030
89685IFC Drawings MailedCCBPhase 040
89685IFC Drawings MailedCCBPhase 050
89685Release to FabricationCCBPhase 010
89685Release to FabricationCCBPhase 020
89685Release to FabricationCCBPhase 030
89685Release to FabricationCCBPhase 040
89685Release to FabricationCCBPhase 050
89685Release to FabricationCCBPhase 080
89685Release to FabricationCCBPhase 090
72589Design CheckCCBPhase 0150
72589Prod DetailCCBPhase 0932
72589Prod DetailCCBPhase 0880
72589Prod DetailVVDPhase 0953
72589Prod DetailVVDPhase 0452
72589Prod DetailVVDPhase 0552
72589ReviewdwgsCCBPhase 0842
72589Prod Check Trim CCBPhase 0812
72589Prod Detail Corrections VVDPhase 0120
72589Prod Detail Corrections VVDPhase 0210
72589Prod Detail Corrections VVDPhase 0435
72589Prod Detail Corrections VVDPhase 0525
72589Prod CheckCCBPhase 0116
72589Prod CheckCCBPhase 0235
72589Prod CheckCCBPhase 0345
72589Prod CheckCCBPhase 0452
72589Prod CheckCCBPhase 0583
72589Prod Detail VVDPhase 0145
72589Prod DetailVVDPhase 0212
72589Prod DetailVVDPhase 0310
72589Prod DetailVVDPhase 0498
72589Prod DetailVVDPhase 0583
72589Design CCBPhase 0188
72589Prod Detail CorrectionsVVDPhase 035
72589Drawings ReviewCCBPhase 017
72589Drawings ReviewCCBPhase 024
72589Drawings ReviewCCBPhase 042
72589Drawings ReviewCCBPhase 0510
72589Prod DetailCCBPhase 093
72589Drawings ReviewCCBPhase 0310
72589Drawings ReviewCCBPhase 090.5
72589Drawings ReviewCCBPhase 090.5
72589MailDrawings CCBPhase 090.5
72589MailDrawings CCBPhase 010.5
72589MailDrawings CCBPhase 020.5
72589MailDrawings CCBPhase 030.5
72589MailDrawings CCBPhase 040.5
72589MailDrawings CCBPhase 050.5
72589Sealing VVDPhase 011
72589Sealing VVDPhase 021
72589Sealing VVDPhase 031
72589Sealing CCBPhase 041
72589Sealing CCBPhase 051
72589Design Release to FabCCBPhase 010
72589IFC Drawings MailedCCBPhase 010
72589IFC Drawings MailedCCBPhase 020
72589IFC Drawings MailedCCBPhase 030
72589IFC Drawings MailedCCBPhase 040
72589IFC Drawings MailedCCBPhase 050
72589Release to FabricationCCBPhase 010
72589Release to FabricationCCBPhase 020
72589Release to FabricationCCBPhase 030
72589Release to FabricationVVDPhase 040
72589Release to FabricationVVDPhase 050
72589Release to FabricationVVDPhase 080
72589Release to FabricationVVDPhase 090
     
     
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous What about this?

Table 2 = 
    VAR __Table = 
        ADDCOLUMNS(
            SUMMARIZE('Table', [PROJECT], [PHASE], "Hours", SUM('Table'[Planned Hours]), "CCB", SUMX(FILTER('Table',[TEAM] = "CCB"),[Planned Hours])),
            "Ratio", DIVIDE([CCB], [Hours])
        )
RETURN
    __Table
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Greg_Deckler ,

     

    I'll keep in mind your suggestion regarding the use of CALCULATE.
    On the other hand I tried this new alternative and the result is the same.

    I wonder if the fact that this table grouping the blank (No PHASE assigned) have something to do with the difference in the results.

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Anonymous Maybe because in this PBIX I get identical results in the summarized table and the table visual. See PBIX below.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Greg_Deckler 

        It took me a while to get back on track and review the option. It did provide the same results, so I decided go back 1 step and summarize the original table removing all the unnecesary criterias, since one of those was affecting the outcome. After that any of the provide options did gives out with the correct assignation ratio so, thanks for the help!