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
Icon for Solution Sage rankSolution 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

 

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    7 years ago
    Hi Anonymous's

    Can you share the measure you are using to calculate the division?

    Based on what you are showing it appears to me that you are not placing the ALL statment to get the red even whe you have other groups. You get infinity because you are diving the quantity by null.

    Regards,
    MFelix