Need Help with Dax

[LCAD_BI]

Hi anyone who can help me,

I have the following totals at the bottom as you can see for each column (g1,g2,and so on);  I need to do the following and get the results as:

i need to take g1 and divide by the ethno number and multiple by 100 to get the percentage. THEN

add g1 and g2 divide by the total ethno number and multiple by 100 to get the percentage. THEN

add g1 and g2 and g3 divide by the total ethno number and multiple by 100 to get the percentage. THEN

add g1 and g2 and g3 and g4 divide by the total ethno number and multiple by 100 to get the percentage. THEN

and so on untill all columns are part of the last calulation.

and at the end be able to get the results based on the filter per slicer.

and help is appriciated  thanks

[v-jiascu-msft · Accepted solution]

Hi @LCAD_BI,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[chotu27]

@LCAD_BIJust be clear what results you need in which visual

[LCAD_BI]

Thanks for the reply.  As you can see from the pic, i am trying to get the results in the excel via PowerBI report.  The Excel formula shows what i am trying to get  thanks

[chotu27]

@LCAD_BIPlease check the image below 

G1,G2,G3 are calculated columns as you said above calculation

[LCAD_BI]

Thanks for the reply.

Simply put, as you can see from the Excel sheet, the purpose is to find the number of gradutes who graduated in 1 year, in 2 years, in 3 years and so on.  Then upon finding the totals per graduation per 1,,2,3,4,5,6, or 7 years,  (at the botoom total)i  need to take the total of each column and do the following to get percentage based on the Excel formula please see pic. thanks again for your help (its a littel kookie math i know.  but i need that). then when i chose ethnicty filter in Powerbe, it should rflect then numbers

for grad 1 year:  =(J37/35)*100

for grad 2 year:  =((J37+K37)/35)*100

for grad 3 year:  =((J37+K37+L37)/35)*100

for grad 4 year:  =((J37+K37+L37+M37)/35)*100

for grad 5 year:  =((J37+K37+L37+M37+N37)/35)*100

for grad 6 year:  =((J37+K37+L37+M37+N37+O37)/35)*100

[chotu27]

please check this wheater it is right and give me  your email id so that i can share pbix file which i done so you can analyze

[LCAD_BI]

rafasg61@msn.com

thanks 

how did you get 7.49?

if i filter the data by Asian, i should get one out of 5  thus 20%

thanks for all you help

[chotu27]

@LCAD_BII did not use any filter here and onething i need to clarify  in the formulae below what is 35 is that total number of rows?

for grad 1 year:  =(J37/35)*100

[LCAD_BI]

Thank you for all your help.  But I solved it over the weekend