Reject Rate by Modèle calculation

[GHAILAN]

Hello community

i have an issue when i want to calculate the rate of reject by modele with this equation

TR = DIVIDE(SUM(Scraps[Scraps Qte]),CALCULATE(SUM('Prod DATA'[Consumption])))

the result in all time very small ==> the filter application only in scrap QTE modele and not on the Consumption model

[amitchandak · Accepted solution]

@GHAILAN , mark it as % column. The calculation seems fine.

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.