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.
Please find below image. 3rd row. Total_Auto Match Per.

 


I am able to achieve this by using Dax but only if I Select Date range for more than one month.

If I select One month range like  1st-Aug- to 31st Aug then in the Aug-20 Month column and Total column both are showing same values.
But I want month column shows percentage and total column show total sum,

 



Dax Formula
Total Value=CALCULATE(COUNT('Fact'[id]) )+0

Total_Auto Match =CALCULATE(COUNT('Fact'[id]),'Fact'[isauto] =1)+0 

Total_Auto Match Per=

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

//Precentage calculation

var Automatch=Divide( Total_Auto Match ,Total Value)

  return

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


How should I go about it. Any help is appreciated.
Thanks

 

Need Help

2 Replies

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

     

  • Icey's avatar
    Icey
    Community 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.