Forum Discussion

homils40's avatar
homils40
Regular Visitor
9 years ago
Solved

Showing % in Matrix

i have the below chart created in a matrix   Staff Time  Manager Time Manager A 4 6 Manager B 5 5 Manager C 6 4 however i would like to add % of staff and % of manager time t...
Need Help
Show and Tell
Tips and Tricks
  • CamFlawless's avatar
    CamFlawless
    9 years ago

    You can add two new measures and then add them to your matrix.

     

    Staff % = DIVIDE(
			SUM(MGRs[Staff Time ]), 
			CALCULATE(SUM(MGRs[Staff Time ]) + SUM(MGRs[Manager Time]), 
			ALL(MGRs[Staff Time ])), 
			
			0)


Mgr % = DIVIDE(
			SUM(MGRs[Manager Time]), 
			CALCULATE(SUM(MGRs[Staff Time ]) + SUM(MGRs[Manager Time]), 
			ALL(MGRs[Manager Time])), 
			
			0)
  • CamFlawless's avatar
    CamFlawless
    9 years ago

    Select the measure on the right side of the UI. Once the measure is selected, click the 'Modeling' tab to the top. From there, you can specify the field format using that 'Formatting' tab. 

CamFlawless's avatar
CamFlawless
Frequent Visitor
9 years ago

Did you try troubleshooting the syntax errors provided to you? The formulas I provided will not be able to be used verbatim; you will need to adjust them to reflect your table[column] names. Mimicing your data structure, the formulas I provided worked to give me your desired output. 

homils40's avatar
homils40
Regular Visitor
9 years ago

ok i think i got it work. how do i get it to show as % rather than just .50 or .40?

  • CamFlawless's avatar
    CamFlawless
    Frequent Visitor
    9 years ago

    Select the measure on the right side of the UI. Once the measure is selected, click the 'Modeling' tab to the top. From there, you can specify the field format using that 'Formatting' tab.