Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Total Measure in Matriz Column

I'm trying to calculate commissions for a Sales Team. I'm almost there...the only thing that I don´t Know to do is "Totalize" the last column. It contains a measures for money...what I want to get it...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    Try this:

    ＄_TOTAL = [＄_Coverage] + [＄_IP]

    ＄_TOTAL_2 = SUMX ( 'The table with the column under 'A.Flores'', [＄_TOTAL] )

     

     

    If this doesn't work either, please share me your .pbix file for test. Please remove sensitive information. It is suggested to upload your file to OneDrive for Business and then paste the link here.

     

     

    Best regards

    Icey

     

    If this post helps,then consider Accepting it as the solution to help other members find it faster.

vanessafvg's avatar
vanessafvg
Community Champion
5 years ago
what calculation are you using for the current total? how do you get that total?

to get the $_total of total is

Total = calculate(sum($_Total))

however the problem is i think how you are plotting your data, if you can give more information about how you are getting details under A.Flores
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, Thank for your answer.

    According your questions...well, I'm using an Excel File with around 10 sheets (mainly: Sales, Goals, Sales Representative, Products, Plans, Markets), all of them linked by a code or unique name. I'm calculating commission based on a Commission Plan Scheme, I mean, I have some rules or condition to check before make a valid calculation, so the only data from data source are the two first columns (Real and Goals), the rest of them are Measures from a new table that I created to put all my new measures (or calculated fields). $_TOTAL colum is a sum of $_coverage + $_IP

    Under A.Flores I'm using data from many tables: Reps, Markets, Products, Goals because I need to compare 2 KPI: Coverage and Performance Index(IP). Coverage is what you did vs what is your goal by product. IP is a comparison between your Market Share by Product and Represenative vs Country Market Share...but that's not a problem...my problem is get a Total of money By Representative (e.j A.Flores) 

    DAX formula that you gave me Total = calculate(sum($_Total)) doesn't work because it doesn´t take $_TOTAL measure (I don´t know why). $_TOTAL measure it's in a my "Measure Table" that I create to put all my new measure

    • vanessafvg's avatar
      vanessafvg
      Community Champion
      5 years ago
      when you say it doesn't work, what happens? how are you creating the measure i gave you? it doesn't really matter where your measures are table wise.