Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I want to display output Matrix B from data table A.
Too difficult for me.
Please Help me !
data table A
Date | DIV | Att | value |
2020/04 | Net Sales | Actual | 600,000 |
2020/04 | Net Sales | Plan | 590,000 |
2020/04 | Cost of Sales | Actual | 300,000 |
2020/04 | Cost of Sales | Plan | 310,000 |
2020/04 | Gross Profit | Actual | 300,000 |
2020/04 | Gross Profit | Plan | 280,000 |
2020/04 | SGA expenses | Actual | 120,000 |
2020/04 | SGA expenses | Plan | 120,000 |
2020/04 | Operating income | Actual | 180,000 |
2020/04 | Operating income | Plan | 160,000 |
2020/05 | Net Sales | Actual | 800,000 |
2020/05 | Net Sales | Plan | 810,000 |
2020/05 | Cost of Sales | Actual | 390,000 |
2020/05 | Cost of Sales | Plan | 400,000 |
2020/05 | Gross Profit | Actual | 410,000 |
2020/05 | Gross Profit | Plan | 410,000 |
2020/05 | SGA expenses | Actual | 125,000 |
2020/05 | SGA expenses | Plan | 130,000 |
2020/05 | Operating income | Actual | 285,000 |
2020/05 | Operating income | Plan | 280,000 |
2020/06 | Net Sales | Actual | 500,000 |
2020/06 | Net Sales | Plan | 490,000 |
2020/06 | Cost of Sales | Actual | 260,000 |
2020/06 | Cost of Sales | Plan | 250,000 |
2020/06 | Gross Profit | Actual | 240,000 |
2020/06 | Gross Profit | Plan | 240,000 |
2020/06 | SGA expenses | Actual | 120,000 |
2020/06 | SGA expenses | Plan | 130,000 |
2020/06 | Operating income | Actual | 120,000 |
2020/05 | Operating income | Plan | 110,000 |
output Matrix B
Slicer : Date = 2020/04
Plan | Actual | |||
TTL Value Plan | composition ratio | TTL Value Actual | composition ratio | |
Net Sales | 590,000 | 100.0% | 600,000 | 100.0% |
Cost of Sales | 310,000 | 52.5% | 300,000 | 50.0% |
Gross Profit | 280,000 | 47.5% | 300,000 | 50.0% |
SGA expenses | 120,000 | 20.3% | 120,000 | 20.0% |
Operating income | 160,000 | 27.1% | 180,000 | 30.0% |
Solved! Go to Solution.
@gaccho_na , You need two measures
M1 = sum(Data[Value])
% = Divide(sum(Data[Value]), calculate(sum(Data[Value]), filter(allselected(Data[DIV]), Data[DIV] = "Net Sales" )))
Please find the attached file after signature
@gaccho_na , You need two measures
M1 = sum(Data[Value])
% = Divide(sum(Data[Value]), calculate(sum(Data[Value]), filter(allselected(Data[DIV]), Data[DIV] = "Net Sales" )))
Please find the attached file after signature
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |