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 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!

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

     

5 Replies

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