Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
77 | |
75 | |
46 | |
31 | |
28 |
User | Count |
---|---|
99 | |
91 | |
51 | |
49 | |
46 |