Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 )
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
76 | |
61 | |
37 | |
33 |
User | Count |
---|---|
99 | |
56 | |
51 | |
42 | |
40 |