Forum Discussion

SUMESHKUMAR22's avatar
SUMESHKUMAR22
Helper IV
2 years ago
Solved

Matrix custom Row Total

Hi community, I'm stuck in a urgency to achieve the attached row total requirement. Please refer the atttached expected screenshots. Pbix sample screenshot: Pbix Link  Instetad of showig the i...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • Fowmy's avatar
    Fowmy
    2 years ago

    SUMESHKUMAR22 

    I think I didn't understand the requirement completely, however try this measure:

    Total Hours = 
IF(
    ISINSCOPE( data[Resource name] ) && SELECTEDVALUE( data[Phase] ) =  "In-Program",
    SUM( data[TOTAL_HOURS_BILLED] ),
    CALCULATE( SUM( data[TOTAL_HOURS_BILLED] ) , ALLSELECTED( data[TIMESHEET MONTH YEAR] )  )
)

     





  • Fowmy's avatar
    Fowmy
    2 years ago

    SUMESHKUMAR22 

    You cannot merger cells in the total row like you do in 

    excel.

    Regarding your second question, you can remove the filter and use it as follows:

     

    Total Hours = 
IF(
    ISINSCOPE( data[Resource name] ),
    SUM( data[TOTAL_HOURS_BILLED] ),
    CALCULATE( SUM( data[TOTAL_HOURS_BILLED] ) , ALLSELECTED( data[TIMESHEET MONTH YEAR] )  )
)

     

Fowmy's avatar
Fowmy
Super User
2 years ago

SUMESHKUMAR22 

I think I didn't understand the requirement completely, however try this measure:

Total Hours = 
IF(
    ISINSCOPE( data[Resource name] ) && SELECTEDVALUE( data[Phase] ) =  "In-Program",
    SUM( data[TOTAL_HOURS_BILLED] ),
    CALCULATE( SUM( data[TOTAL_HOURS_BILLED] ) , ALLSELECTED( data[TIMESHEET MONTH YEAR] )  )
)

 





SUMESHKUMAR22's avatar
SUMESHKUMAR22
Helper IV
2 years ago

Hi Fowmy , Thanks for the prompt response.
Is it possible to get the 195.20 to be displayed 1 time across the row instead of repeating it for every monthyear ? Just to get the row totals should get displayed once.

Also, to run this measure for all phases should I remove the 'In-program' filter ?

Total Hours = 
IF(
    ISINSCOPE( data[Resource name] ) && SELECTEDVALUE( data[Phase] ),
    SUM( data[TOTAL_HOURS_BILLED] ),
    CALCULATE( SUM( data[TOTAL_HOURS_BILLED] ) , ALLSELECTED( data[TIMESHEET MONTH YEAR] )  )
)



Thanks ,

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    SUMESHKUMAR22 

    You cannot merger cells in the total row like you do in 

    excel.

    Regarding your second question, you can remove the filter and use it as follows:

     

    Total Hours = 
IF(
    ISINSCOPE( data[Resource name] ),
    SUM( data[TOTAL_HOURS_BILLED] ),
    CALCULATE( SUM( data[TOTAL_HOURS_BILLED] ) , ALLSELECTED( data[TIMESHEET MONTH YEAR] )  )
)