Forum Discussion

DrillDownBI's avatar
DrillDownBI
Helper I
1 year ago
Solved

Measure Total, again

Hi, this is my third day struggling with measure total, time to get some help. I have 3 columns in my matrix tabel that should be summarized row by row, and then ofcource sum up everything in the t...
DAX
matrix
  • DrillDownBI's avatar
    DrillDownBI
    1 year ago

    I finally find a solution for this.

    I use summarize in a temp table and then sumx like below DAX code.

    VAR _stdInflation =
                    Summarize(
                        'Calendar', --Table
                        'Calendar'[Period], --Group by
                            "@value", --name of expression                    
                            CALCULATE(
                                SUM(FactTable[ActualPrel]),
                                    SAMEPERIODLASTYEAR('Calendar'[Period])
                            ) ,
                            "@value2",    
                                 CALCULATE(
                                           SUM(Summary[Inflation])                      
                                             
                                 )
                    )
                              RETURN SUMX(_stdInflation ,[VALUE] *[@value2]  )  
DrillDownBI's avatar
DrillDownBI
Helper I
1 year ago

I finally find a solution for this.

I use summarize in a temp table and then sumx like below DAX code.

VAR _stdInflation =
                Summarize(
                    'Calendar', --Table
                    'Calendar'[Period], --Group by
                        "@value", --name of expression                    
                        CALCULATE(
                            SUM(FactTable[ActualPrel]),
                                SAMEPERIODLASTYEAR('Calendar'[Period])
                        ) ,
                        "@value2",    
                             CALCULATE(
                                       SUM(Summary[Inflation])                      
                                         
                             )
                )
                          RETURN SUMX(_stdInflation ,[VALUE] *[@value2]  )  
  • v-aatheeque's avatar
    v-aatheeque
    Community Support
    1 year ago

    Hi DrillDownBI ,

    Thank you so much for sharing your solution.

    It’s great that you included your DAX code here, as it could really help other community members facing the same challenge.

    Feel free to keep exploring and posting your questions or solutions here in the Fabric Community your contributions are truly valuable!