Forum Discussion

GKs's avatar
GKs
Frequent Visitor
7 years ago
Solved

Calculate and Divide Together

I am really a beginner with this tool, I am trying to make this calculation with DAX, however it does not show how I would like it.       I know something is wrong, I can not find that    ...
Need Help
  • affan's avatar
    affan
    7 years ago

    Hi GKs,

     

    As you have mentioned that you are a beginner I have attached a power bi pbix file which you can download from link below.

     

    https://www.dropbox.com/s/zpfk3yfpdevwbul/SalesPercent.pbix?dl=0

     

    in this file I have tested the following result.

     

     

     

    If this helped you, please mark this post as an accepted solution and like to give KUDOS .

     

    Regards,

    Affan

affan's avatar
affan
Solution Sage
7 years ago

Hi GKs,

 

As you have mentioned that you are a beginner I have attached a power bi pbix file which you can download from link below.

 

https://www.dropbox.com/s/zpfk3yfpdevwbul/SalesPercent.pbix?dl=0

 

in this file I have tested the following result.

 

 

 

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

 

Regards,

Affan

  • GKs's avatar
    GKs
    Frequent Visitor
    7 years ago

    replicate the same formula and only divide the red / red, the other values are infinity

    • affan's avatar
      affan
      Solution Sage
      7 years ago

      Anonymous

       

      Have you tried downloading and checking the sample file I have shared?

      • GKs's avatar
        GKs
        Frequent Visitor
        7 years ago

        if I did, however it remains the same with infinity