Forum Discussion

ShubhamBarnwal's avatar
ShubhamBarnwal
Frequent Visitor
6 years ago
Solved

Customized Total Row in table Visualization

Hello,   I am looking to get a customized value in the total row for table visualization in Power BI. Below is the screenshot of the task I am trying to achieve. "Budget" total is simply the sum o...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    ShubhamBarnwal try this measure

     

    % = 
IF ( 
    HASONEFILTER( 'Table'[Desc] ), 
    SUM ( 'Table'[% Complete] ), 
    DIVIDE ( 
        SUMX ( 'Table',  CALCULATE( SUM ( 'Table'[Budget] ) ) * CALCULATE( SUM ( 'Table'[% Complete] ) ) ),
        CALCULATE( SUM ( 'Table'[Budget] ), ALL() )
    )
)

     you can always create SUM measures for Budget and % Complete and use those in above measure.

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    ShubhamBarnwal try this measure

     

    % = 
IF ( 
    HASONEFILTER( 'Table'[Desc] ), 
    SUM ( 'Table'[% Complete] ), 
    DIVIDE ( 
        SUMX ( 'Table',  CALCULATE( SUM ( 'Table'[Budget] ) ) * CALCULATE( SUM ( 'Table'[% Complete] ) ) ),
        CALCULATE( SUM ( 'Table'[Budget] ), ALL() )
    )
)

     you can always create SUM measures for Budget and % Complete and use those in above measure.