Forum Discussion

sbg94's avatar
sbg94
Microsoft Employee
5 years ago

Adding Custom Total column in Matrix Visual

  Hi All, I have been trying to create a matrix with some data. I want to show data with respect to year and month. I want to show the Total sum Infront of percentage row in the total column. Ple...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

sbg94 , Not able to get your issue. Can you explain with example ?

 

Also for your % measure use % , 2 decimal from measure tool

Create it like
var Automatch= Divide( Total_Auto Match ,Total Value)

return

IF([Total Value]>=totalRequests ,[Total_Auto Match] ,Automatch)