Calculate Percentage on Columns

[Syndicate_Admin]

Dear

I have the following table (visual), I have data from the "Ranking, Total Events, No Count, and Yes Count" columns.

This data varies with date filtering.

I need to get the "Yes Percentage" column, as shown in the attached table, calculated as: " (Yes Account)*100/(No Account) .

In the "Total" row, I need you to enter the total percentage over total events, not the average of the percentages in the same column.

Please help with how to implement the solution.

Best regards

Classification	Total Events	Account No	Account Yes	Percentage Yes
A	3	1	2	67%
B	3	0	3	100%
C	16	1	15	94%
D	1	0	1	100%
Total	23	2	21	91%

[v-xinruzhu-msft · Accepted solution]

Hi @Syndicate_Admin 

You can create a measure

Measure =
SUMX (
    VALUES ( 'Table'[Classification] ),
    DIVIDE ( SUM ( 'Table'[Account Yes] ), SUM ( 'Table'[Total Events] ) )
)

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Data-estDog]

Try this:

Dax: 

PercentYes = DIVIDE(SUMX(Class,Class[YesAccount]), SUMX(Class, Class[TotalEvents]))

Be sure to mark as the solution and thumbs up if I help you!