Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good day,
I am trying to get the total of my row level data and not the total on the column (See example below)
Store 1 Store 2 Store 3 Total
Sales 10000 12000 7000 29000
Profit Margin % 10% 15% 18% 18%
Profit 1000 1800 1260 5220
I want to be able to work out a way to get my profit total to be 1000+1800+1260 = 4060.
I am not sure what to do about the total profit margin % as that is irrellevant for the total figure I just need total profit.
I am currently using MAX(Profit margin %) in order to bring it into a measure
I am pulling in sales figures from multiple tables in a measure and the profit margin from multiple tables in a measure.
Any assistance would be greatly appreciated.
Thanks in advance!
Can you not transpose your source data once it's all loaded up into Power Query, or use the features that the matrix visual has?
So, is that source data or the result shown in a Table or Matrix visualization?
That is the result shown in a matrix
Sales and Profit Margins are both measures.
Did you turn on Column subtotals? I know it soundsl like the wrong thing but it should give you a column of totals on the right. It's in the format area under Subtotals.
I have put in the totals but it does not calculate the total properly.
I am not sure how to bring the profit margin percentage into a measure without using a MAX or MIN.
For example Profit measure = Sales x MAX(ProfitMargin)
The total then works out total sales times the max profit margin which is incorrect
hi, @AdamIzzo
This looks like a measure totals problem.See this post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
IF not your case,Please share your sample pbix for us. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading
Best Regards,
Lin
Thanks I will look into this!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |