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
        )
    )
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
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?

         
         
    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      Anonymous 

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