Percentage Issue

[Anonymous]

Hello exports, 
Here I want the the 5 countries by percantage, but when I did that, it give percet of each country of thr gradn total of this top 5 as you see in right table.
But What I want is to give the 5 countries of grand total for all countries as you see in left table, but I want the top 5 only. What the DAX code to do that?

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Value country: = 
SUM( Data[Value] )

Value percent grandtotal: = 
VAR _valueall =
    CALCULATE ( [Value country:], ALL () )
RETURN
    DIVIDE ( [Value country:], _valueall )

Top five percent: = 
CALCULATE (
    [Value percent grandtotal:],
    KEEPFILTERS (
        TOPN (
            5,
            ADDCOLUMNS (
                ALL ( Data[Country] ),
                "@valuepercent", [Value percent grandtotal:]
            ),
            [@valuepercent], DESC
        )
    )
)

[Anonymous]

Good Work Mr. Jihwan.

but I am not understad the line I highlited. How I can made in my measure>>

[tamerj1]

@Anonymous 

This is a name given to a virtual column created by ADDCOLUMNS  therefore just type it as is

[Jihwan_Kim]

Hi,

Sorry that I quite do not understand your question.

You can check my attached file, or, please share your sample pbix file's link here, and then I can try to look into it to provide a more accurate solution for your data model.

Thanks.

[Anonymous]

Hello Sir, sorry my data is confidital.

My quesion is what are ( "@valuepercent" and [@valuepercent]) meaning??
my measure is same for you, but I dont know what I mentioned before meaning and how I write in my measure?