Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Percentage Issue

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 ...
Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

Good Work Mr. Jihwan.

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

 

 

Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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?