Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ShareefHussain
New Member

PowerBi-Divide Issue

Dear All,

Getting incorrect Ratio while using the Divide formula, Seems it taking overall backend numbers not Data present on the table. Could you please help fix this issue?

ShareefHussain_0-1695454125227.png

Regards

Shareef

2 ACCEPTED SOLUTIONS

Hi @ShareefHussain 

You should use measures for this kind of calculation.
I modified it on your file, you can download it from the Link 

For more information about the differences please refer :
https://www.tpximpact.com/knowledge-hub/blogs/tech/power-bi-measures-calculated-columns/

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

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

 

View solution in original post

ShareefHussain
New Member

@Ritaf1983 Thank you so much 😍.

View solution in original post

5 REPLIES 5
ShareefHussain
New Member

@Ritaf1983 Thank you so much 😍.

Glad to help 🙂

Ritaf1983
Super User
Super User

Hi @ShareefHussain 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Good day @Ritaf1983 ,

 

Thank you for your response. Please find the link below for PowerBi file & source data in excel file for your reference.

Excel:- Excel File - Source Data

 

PowerBi:- PowerBI 

 

Based on this outcome we can find out the Rejection % in various factors, like Year, Mode, Name, etc.

 

Regards

Shareef

 

Hi @ShareefHussain 

You should use measures for this kind of calculation.
I modified it on your file, you can download it from the Link 

For more information about the differences please refer :
https://www.tpximpact.com/knowledge-hub/blogs/tech/power-bi-measures-calculated-columns/

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

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

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors