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

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

Thnaks in advance!

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    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.