Help with dividing values

[Anonymous]

Hi! 

I need help with dividing two values to create a new measure. This measure should show the sum of X divided by Y. However, after creating such a measure, the output is a bit off. My two values are 19 and 26, and when I divide those two values Power BI gives me 79.2%, but this is not correct as 19 / 26 = 73.1%. 

The DAX expression I have created in order to give the faulty output is: 

CALCULATE(COUNTROWS(Tablename1)/sum(Tablename2[columnname]))

Hopefully you can help as I do not see what I am doing wrong but still getting the faulty output.

Thanks!

[v-deddai1-msft]

Hi @Anonymous ,

It'e better that you can show us some sample data (sample pbix file ) by onedrive for business for referenece. Then we can can help you well.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@Anonymous , Try like , see if that give better result. Also change decimal place to 2 and check

CALCULATE(divide(COUNTROWS(Tablename1)*1.0,sum(Tablename2[columnname])))

[Anonymous]

Hi again, 

So the measure is correct however when I apply filters (such as date) this is when the output becomes wrong. The standard deviation also increases the lower the values I wish to divide. So for instance 2 / 3 is more faulty than 200 / 300 .

[Anonymous]

Hi, 

Thank you for answering but it still gives me the same faulty output, same number.. Not really sure why it does not show the correct value