Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
mith_tina
Frequent Visitor

how to get row value divide total row

on below table, i need to show the percenrage. how can i write dax for getting the percentage value(52439 / 437567=11.98%).

i tried to write this dax but it didnt get me the accurate answer. please help me to write the dax

 
Perent of Total =
DIVIDE (
COUNT('Table'[ID]),
CALCULATE ( COUNT('Table'[ID] ), ALLEXCEPT ('Table',[JL]) )
)

 

 

c10628936853962563744048276686402437567  
male722679287401857110799105145243911.98% 
female22756252452269826288288763034515620835.69% 
c9401064872945906474814745748561278240  
male352642754209420042324704251469.03% 
1 REPLY 1
lbendlin
Super User
Super User

please check your sample data again - seems to be missing the column headers.  Is this how you get the data from the source?

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.