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

PROJECT/PHASE_RATIO = 
SUMMARIZE( 'TONS/PHASE TABLE'
          , 'TONS/PHASE TABLE'[PROJECT]
          , 'TONS/PHASE TABLE'[PHASE]
          , "ASSIGN_RATIO_BY_PHASE", 
                [ASSIGN_RATIO_BY_PHASE],
          , "RELEASE_TO_FAB_DATE", 
                CALCULATE( 
                    MAX( 'TONS/PHASE TABLE'[ACT_FINISH_DATE] )
                    , FILTER('TONS/PHASE TABLE', 'TONS/PHASE TABLE'[TASK] = "Release to Fabrication" )
                )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Greg_Deckler thank you,

    I did it but the result is the same. The percentages remain the same in the SUMMARIZE table!
    Any idea!!!