Dear Mr. With Dimitar Shutev, All entries of %Sales show 100.00. Please tell why it happens like that. Amy Soe

OK. I try replacing with country inside ALL function like ... TotalSalesAmountAll = CALCULATE([TotalSalesAmount],ALL(dim_SalesTeritory)) Now, it works fine. Please see my attached screenshot. Thank you so much. The whole course explanation are really helpful for us.

can you please provide your DAX code?

DAX code for %Sales is: %Sales = DIVIDE([TotalSalesAmount],[TotalSalesAmountAll])*100

ok, and what is inside TotalSalesAmountAll? Can you please share that as well?

TotalSalesAmountAll = CALCULATE([TotalSalesAmount],ALL(dim_Currency))

Please try replacing dim_Currency with country inside the ALL function

Follow this topic

Amy Soe

Last answered:

03 Nov 2021

Posted on:

03 Nov 2021

Power BI Final Project part 13

in Power BI / Final Project, Part 13

7 answers ( 0 marked as helpful)

Dimitar Shutev

Instructor

Posted on:

03 Nov 2021

Amy Soe

Posted on:

03 Nov 2021

Amy Soe

Posted on:

03 Nov 2021

Dimitar Shutev

Instructor

Posted on:

03 Nov 2021

Amy Soe

Posted on:

03 Nov 2021

Dimitar Shutev

Instructor

Posted on:

03 Nov 2021

Amy Soe

Posted on:

03 Nov 2021

Power BI Final Project part 13

Submit an answer

related questions