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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.