Forum Discussion
Problem with Power BI Desktop Calculations
I'm relatively new to using Power BI Desktop, and I need your support because I've been stuck on this issue for weeks without finding a solution.
I was tasked with creating a Pareto chart, but the calculation I've been working on has been giving me errors. I attempted to create the formula in two ways: by calculating a new column and by calculating a new measure. The formula for the measure is correct, meaning it provides the data I need. However, when I replicate the same formula by creating a column, I get different results.
The column calculation is named "Test," and the measure calculation (the one that's correct) is named "Evaluation."
Could you please assist me with this matter?
5 Replies
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hello, I apologize, I didn't know how to do it. I'm leaving you the link to download the files on Drive. I appreciate your support in advance.
https://drive.google.com/drive/folders/1rGf3rtCbFv6jJYF0B78uFT0jEzmN9fWh?usp=drive_linkYour measure is aggregated by Date, Warehouse, and Product Number. Calculated columns work on row level, not on aggregation level. Do you want to apply your rules to the individual rows, or do you want to repeat the same result for all combinations of Date, Warehouse, Product?
By the way, your measure can be refactored a bit:
Evaluation = SWITCH(TRUE(), [SUM Order]<=0 || [AVG SL]>=1,"", [AVG InvN]>=[SUM Order],"Not Assorted", [SUM Order]>(3*[AVG NetOrder]),"Ext Demand", [AVG InvT]=0,"Out of Stock", [AVG InvT]>0 && [AVG InvT]<(3*[AVG NetOrder]),"Ins Supply", [AVG InvT]>0 && [AVG InvT]>=(3*[AVG NetOrder]),"Prod Transit", "")
