Forum Discussion
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's the following Total 6.521,9 (not 1.263).
How Can I get this?
I
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.
4 Replies
- 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.FloresHi, 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
- 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.
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.
