The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
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% |
please check your sample data again - seems to be missing the column headers. Is this how you get the data from the source?