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.

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!