Forum Discussion

sbg94's avatar
sbg94
Icon for Microsoft Employee rankMicrosoft 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
Icey's avatar
Icey
Icon for Community Support rankCommunity Support
5 years ago

Hi sbg94 ,

 

It is needed to change the calculation logic of "Total_Auto Match Per" measure.

Total_Auto Match Per=

var totalRequests =CALCULATE(COUNT('Fact' [id]),ALLSELECTED('Fact'))

var Automatch=Divide( Total_Auto Match ,Total Value)

  return

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

 

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.