CALCULATE % not showing properly

[Anonymous]

Hello everone.

I need to show Sales % by countries. The sales % was showed properly before i add Currency Code. After i add Currency code column Sales % looks by every currency like in this photo. 

i used this DAX expression : 

Sales % by country = DIVIDE(

SUM(Book_Settles[Sales_Amount]),

CALCULATE(

SUM(Book_Settles[Sales_Amount]),

ALL(Shop[Nation_Name])

)

)

i dont need to show  every currency type %. i need to show the Sales % by countries when Currency code column is in the table.  So How to change my DAX expression.🤔. PLEASE HELP ME

🤔🤔

Thank you 😊

[v-lionel-msft]

Hi @Anonymous ,

Try the two measures:

Sum of sales = 
CALCULATE(
    SUM(Sheet13[Sales_Amount]),
    ALLEXCEPT(
        Sheet13,
        Sheet13[Nation_Name]
    )
)
//
Sales % by country = 
DIVIDE(
    [Sum of sales],
    CALCULATE(
        SUM(Sheet13[Sales_Amount]),
        ALL(Sheet13)
    )
)

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lili6-msft]

HI @Anonymous 

Adjust your formula as below:

Sales % by country 2 = 
DIVIDE(
    SUM( Book_Settles[Sales_Amount] ),
    CALCULATE(
        SUM( Book_Settles[Sales_Amount] ),
        ALL( Shop[Nation_Name]),ALL(Book_Settles[Currency_Code])))

Regards,

Lin

[Anonymous]

Hi @Anonymous ,

use below DAX, replace ALL(Shop[Nation_Name]) to ALL(Shop),

Sales % by country = DIVIDE(

SUM(Book_Settles[Sales_Amount]),

CALCULATE(

SUM(Book_Settles[Sales_Amount]),

ALL(Shop)

)

)

Best Regards,

Mail2inba4

[Mariusz]

Hi  @Anonymous 

Try adjusting your ALL() expression like below.

Sales % by country = 
DIVIDE(
    SUM( Book_Settles[Sales_Amount] ),
    CALCULATE(
        SUM( Book_Settles[Sales_Amount] ),
        ALL( Shop )
    )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

[Anonymous]

Shop is a table name. Even i  replace Nation name in Dax by Shop name, % doesnt look, it look all 100%