Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I'm trying to calculate the count of production orders which have a deviation percentage above 5%, i.e. count rows of production orders in which a deviation percentage criteria is met.
DeviationPercentage = (sum(Table1[ActualAmount])-sum(Table1[ReqAmount]))/sum(Table1[ReqAmount])
For 5% deviation I have created the following measure where the above measure is used in filter criteria:
However when I filter on a certain product the "Production Orders across time" visualization works fine.
Solved! Go to Solution.
I was able to solve this with a summarized temp table and
I was able to solve this with a summarized temp table and
@morbu , Try a measure like
Countx(FILTER(VALUES(Table1[ProductionOrder]),[DeviationPercentage]>=0.05),Table1[ProductionOrder])
else
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
I'm afraid your suggestion gives the same result as outlined
@morbu ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
check this version too
Countx(FILTER(summarize(Table1[ProductionOrder],"_1",[DeviationPercentage]),[_1]>=0.05),Table1[ProductionOrder])
I will try share some sample data/PBIX a bit later
One thing come to mind that might have an impact
Previously I outlined DeviationPercentage as = (sum(Table1[ActualAmount])-sum(Table1[ReqAmount]))/sum(Table1[ReqAmount])
In reality DeviationPercentage = (ActualBlender-ReqBlender)/ReqBlender
where
ActualBlender = calculate(sum(Table1[ActualAmount], Table1[Line]"Blender"
ReqBlender = calculate(sum(Table1[ReqAmount], Table1[Line]"Blender"
Table1 consists of "Blender" and "Press" as values for [Lines]
User | Count |
---|---|
119 | |
95 | |
87 | |
74 | |
65 |
User | Count |
---|---|
138 | |
112 | |
110 | |
98 | |
94 |