Hello,
I am attempting to recreate a Tableau dashboard and the data that was provided to me is in a pivot format. I've managed to unpivot the columns Revenue, Cost, Profit and % of Profit for the matrix table. The issue I am facing is that the column, % of profit is summing up rather than returning the single value for a given team and month. Is there a way to prevent the % of profit from summing? Any advice / tips would be greatly appreciated.
Original data
new measures for % of profit
new table to unpivot data
% of profit column is summing 😞
Solved! Go to Solution.
Hello @NedFlanders01
You can write a measure to calculate the % of profit correctly:
% of Profit Measure = VAR RevenueSum = SUM ( table[Revenue] ) VAR ProfitSum = SUM ( table[Profit] ) RETURN DIVIDE ( ProfitSum, RevenueSum )
Hello @NedFlanders01
You can write a measure to calculate the % of profit correctly:
% of Profit Measure = VAR RevenueSum = SUM ( table[Revenue] ) VAR ProfitSum = SUM ( table[Profit] ) RETURN DIVIDE ( ProfitSum, RevenueSum )
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
107 | |
74 | |
66 | |
49 | |
48 |
User | Count |
---|---|
164 | |
87 | |
77 | |
70 | |
67 |