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 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?

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
        )
    )
)

5 Replies

  • 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.