Message 2 of 4 2,744 Views 1 Otherwise, the These calculations are measures. Instead of selecting one customer at a time, you can also change the slicer settings so that selecting multiple customers would also be possible. Web15K views 1 year ago Power BI This video will show you exactly how to calculate percentages correctly down a column based on the column total and with sub groups. Although you might have already learned this from the other modules, reviewing it would be beneficial for its common usage in various scenarios. By taking a step-by-step approach, you can more easily see what's going on and how to solve the problem. However, Then: Pct_Tot = VAR Actual_Total = CALCULATE ( SUM ( Table [Act] ), ALL ( Table [Cat] ) ) RETURN DIVIDE ( SUM (Table [Err]), Actual_Total ) Attend online or watch the recordings of this Power BI specific conference, which includes 130+ sessions, 130+ speakers, product managers, MVPs, and experts. What's the difference between a power rail and a signal line? According to your description, here's my solution. When you calculate ratios of a product compared to all products but keeping the filter both by year and region. How can we calculate % ratio of one measure & one column? Click Modeling, Calculations, New Column. Any help would be appreciated.. powerbi powerquery powerbi-custom-visuals Share Improve this question You can always delete quick measures from your model if you don't like them by right-clicking or selecting the next to the measure and selecting Delete from model. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. It is important to select the right table because if you choose wrong, you will have to delete and recreate the column in the right table. I prefer this technique: =Calendar(