top N Percentage of total

[ArashZ]

Hi,

I would like to have a graph to calculate the top 2 languages with their percentage of the total for the table below:

User	Language
A	English
A	French
B	English
B	French
B	French
C	English
D	English
E	Spanish
F	English

The answer should look like the graph below. Please note that the answers should show the English and French with 55.56 and 33.33 percent respectively.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

I assume the table has a column (Index column or date column, for instance) to differenciate each row that is shown in the question.

Top two count percent: =
VAR _totalcount =
    CALCULATE ( COUNTROWS ( Data ), REMOVEFILTERS () )
VAR _toptwocount =
    CALCULATE (
        COUNTROWS ( Data ),
        KEEPFILTERS (
            TOPN ( 2, ALL ( Data[Language] ), CALCULATE ( COUNTROWS ( Data ) ), DESC )
        )
    )
RETURN
    DIVIDE ( _toptwocount, _totalcount )