cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## How to create composition ratio in powerBI ---2

Hello,

I want to display output Matrix B from data table A.

Too difficult for 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%
1 ACCEPTED SOLUTION
Super User

@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

Super User

@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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors