Calculate percentage on direct query

Question

Hi all (:I would appreciate your help.I want to calculate a percentage on direct query.&nbsp;I calc the count(*) "country" and I an not&nbsp;succeed to&nbsp;calculate the percentage&nbsp;The data :Country&nbsp; &nbsp; &nbsp; &nbsp; color of the flag&nbsp;&nbsp;--------------------------------USA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;red&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;USA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;white&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;USA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Greece&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; White&nbsp;Greece&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; blueThe&nbsp;The desired result:Country&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sum(count())&nbsp; &nbsp;Percent%USA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 60%Greece&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40%&nbsp;Thanks,sin&nbsp;&nbsp;

v-juanli-msft · Accepted Answer

Hi Anonymous&nbsp;
A little change based Rocco_sprmnt21 query, delete *100, after close &amp;&amp;apply, change the data column to "percentage" format.
Also, since it is direct query mode, you could also try to create a measure like:
Measure 3 =
CALCULATE (
    COUNT ( 'Table 2'[color of flag] ),
    ALLEXCEPT (
        'Table 2',
        'Table 2'[Country]
    )
)
    / CALCULATE (
        COUNT ( 'Table 2'[color of flag] ),
        ALL ( 'Table 2' )
    )

Best RegardsMaggieCommunity Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Calculate percentage on direct query

2 Replies

Related content

Direct Lake Model - Calculated Column/Tables

Calculate Percentage

Calculating Percentages

percentage calculation

Calculate percentage