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 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

 

 

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

9 Replies

    • LCAD_BI's avatar
      LCAD_BI
      Frequent Visitor
      9 years ago

       

      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'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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    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