Forum Discussion

LCAD_BI's avatar
LCAD_BI
Frequent Visitor
9 years ago
Solved

Need Help with Dax

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 an...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    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's avatar
chotu27
Post Patron
9 years ago

LCAD_BIPlease check the image below 

 

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

LCAD_BI's avatar
LCAD_BI
Frequent Visitor
9 years ago

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's avatar
    chotu27
    Post Patron
    9 years ago

    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's avatar
      LCAD_BI
      Frequent Visitor
      9 years ago

      [email protected]

       

      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's avatar
        chotu27
        Post Patron
        9 years ago

        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