Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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]
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.