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

       

  • 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.