Matrix custom Row Total

[SUMESHKUMAR22]

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 individual total for each monthyear it should give a single Totalsum by Department & phase wise (In-program & pre-program).
What measure should be written to achive this ?

Sample image for reference (Optional) :


Let me know if any clarification needed.

Thanks in advance!

[Fowmy · Accepted solution]

@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 · Accepted solution]

@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]

@Fowmy , 
Is it possible to do the conditional formatting on the higlighted column Total?

Thnaks in advance!

[Fowmy]

@SUMESHKUMAR22 

Yes, it is possible, open a seperate question as the solution I gave you is to resolve your original question. Accept it as a solution if it works for you.
 

[SUMESHKUMAR22]

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 · Accepted solution]

@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] )  )
)