Forum Discussion
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]) )
)
| c10 | 62893 | 68539 | 62563 | 74404 | 82766 | 86402 | 437567 | ||
| male | 7226 | 7928 | 7401 | 8571 | 10799 | 10514 | 52439 | 11.98% | |
| female | 22756 | 25245 | 22698 | 26288 | 28876 | 30345 | 156208 | 35.69% | |
| c9 | 40106 | 48729 | 45906 | 47481 | 47457 | 48561 | 278240 | ||
| male | 3526 | 4275 | 4209 | 4200 | 4232 | 4704 | 25146 | 9.03% |
1 Reply
- lbendlin
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?
