My First Data Modeling Workout 001

Workouts Power BI
1

Total Sales =
SUMX( Sales,
Sales[Quantity] * Sales[Unit Price] ) + 0

Total Costs =
SUMX( Sales,
Sales[Quantity] * Sales[Unit Cost] ) + 0

Canada Sales =
CALCULATE(
[Total Sales],
FILTER( ALL( Stores ), Stores[Country] = “Canada” )
) + 0

US Sales =
CALCULATE(
[Total Sales],
FILTER( ALL( Stores ), Stores[Country] = “United States” )
) + 0

Computer Sales =
CALCULATE(
[Total Sales],
FILTER( ALL( Products ), Products[Product Category] = “Computers” )
) + 0

Online Sales =
CALCULATE(
[Total Sales],
FILTER( ALL( Channels ), Channels[Channel] = “Online” )
) + 0

Blue Sales =
CALCULATE(
[Total Sales],
REMOVEFILTERS(),
FILTER( ALL( Products ), Products[Colour] = “Blue” )
) + 0

Red Sales =
CALCULATE(
[Total Sales],
REMOVEFILTERS(),
FILTER( ALL( Products ), Products[Colour] = “Red” )
) + 0

2007 Sales =
CALCULATE(
[Total Sales],
REMOVEFILTERS(),
FILTER( ALL( Dates ), Dates[Year] = 2007 )
) + 0

2008 Sales =
CALCULATE(
[Total Sales],
REMOVEFILTERS(),
FILTER( ALL( Dates ), Dates[Year] = 2008 )
) + 0

2009 Sales =
CALCULATE(
[Total Sales],
REMOVEFILTERS(),
FILTER( ALL( Dates ), Dates[Year] = 2009 )
) + 0

2010 Sales =
CALCULATE(
[Total Sales],
REMOVEFILTERS(),
FILTER( ALL( Dates ), Dates[Year] = 2010 )
) + 0![Workout 001 Power BI|690x460](upload://5Jf6wj0Iw7TRpweND488aESM8WX.png) [Data Modeling Workout 01 by Rasheed.pbix|attachment](upload://dWnLRKJIUFOZoCMHn8QNiFGp0mU.pbix) (219.7 KB)

2

Hi @Shidy

Welcome to the community. I’d like to check if this is your official entry for Data Modeling Workout 001.

if so please post your entry as a reply to the Workout thread so that you can be awarded of the 50 XP Points.

I can transfer this to the Thread but I will need your confirmation.

Thank you!

3

Thanks for acknowledging the post, You can go ahead to transfer it to the thread aforementioned. Thanks!

4

A post was merged into an existing topic: Data Modelling Workout 01 - Star Schema

5

Moved. Thank you!