Calculate and Divide Together

[GKs]

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 

[affan · Accepted solution]

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]

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

[affan]

@GK

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

[GKs]

if I did, however it remains the same with infinity

[MFelix]

Hi @GK'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

[MFelix]

Hi @GKs,

Add the following measure to your data model:

% = 
var Red_sales = CALCULATE(SUM(Sales[Sales]);Sales[Group] = "Red")
Return
 SUM(Sales[Sales]) / Red_sales

Should give you the expected result

Regards,

MFelix