Last answered:

11 Nov 2024

Posted on:

20 Apr 2021

0

Resolved: the total sales amount for USA comes as 9M not 9.39M as in the video so can you please advise?!

the total sales amount for USA comes as 9M not 9.39M as in the video so can you please advise?!

8 answers ( 1 marked as helpful)
Instructor
Posted on:

20 Apr 2021

0

Can you please show me your DAX code?

Posted on:

20 Apr 2021

0

SalesAmountUnitedStaets = CALCULATE(SUM(fact_InternetSales[SalesAmount]),dim_SalesTeritory[SalesTerritoryCountry] = "United States")

Instructor
Posted on:

20 Apr 2021

0

hmm, I cannot find anything wrong with your DAX, what about the rest of the formulas, are they matching what you see in the video? You can do a simple comparison if you drag the TotalSalesAmount measure into a table or matrix table and drag SalesTerritoryCountry as a dimension to see a full breakdown of sales by territory.

Posted on:

21 Apr 2021

0

All the rest is okay and are the same,

I just did like what you said and here is the result

image.png

Posted on:

21 Apr 2021

0

I think It get the number close rounding to 0 because it does the same for all other countries so is there any way to avoid that?

Instructor
Posted on:

21 Apr 2021

1

image
Please select the measure and go to Measure Tools from there you can choose the format and if to use decimals, thousands separators, etc.

Posted on:

22 Apr 2021

1

Just wow now it works, thx a lot

image.png

Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

11 Nov 2024

0
amazing, thanks it wrked

Submit an answer