Forum Discussion

ponczula's avatar
ponczula
Frequent Visitor
2 years ago
Solved

Power BI Desktop - total row does not sum up

Dear Members, got stucked with what seems to be an easy ride, but apparently is above my skillset and somehow wasn't able to find out correct answer.   Case: Have both LBE and AOP. Not all manage...
Need Help
  • ponczula's avatar
    ponczula
    2 years ago

    Hi all,

    I have sorted out the case by myself by wraping the entire calculation into another measure with SUMX & SUMMARIZE function which eventually picks the total row in correct manner.

     

    In other words:

    1. Frist - calculating LBE measure as stated earlier
    2. Second - calculating LBE final measure as stated earlier
    3. Third - calculating new measure LBE TOTAL as per below formula:
    LBE TOTAL =
    SUMX (
        SUMMARIZE ( 'DB', Regions[Region Name], "TOTAL", SUM ( 'DB'[USD] ) ),
        [LBE final]
    )
     
    Hope this helps community as well!
     
ponczula's avatar
ponczula
Frequent Visitor
2 years ago

Hi all,

I have sorted out the case by myself by wraping the entire calculation into another measure with SUMX & SUMMARIZE function which eventually picks the total row in correct manner.

 

In other words:

  1. Frist - calculating LBE measure as stated earlier
  2. Second - calculating LBE final measure as stated earlier
  3. Third - calculating new measure LBE TOTAL as per below formula:
LBE TOTAL =
SUMX (
    SUMMARIZE ( 'DB', Regions[Region Name], "TOTAL", SUM ( 'DB'[USD] ) ),
    [LBE final]
)
 
Hope this helps community as well!