Forum Discussion
Anonymous
5 years agoNot applicable
DAX Measure ALL
Hi I have requirements to get the % of defect using the formula defect % = defect count / volume qty. the problem is i'm getting the overall volume qty even i'm using a month filter from a p...
amitchandak
5 years agoSuper User
Anonymous ,
Try like
volume qty= CALCULATE(table[defect Count], ALLSELECTED(table))
Anonymous
5 years agoNot applicable
Thank you.
The code is working fine when i used to the first type of defect. but when i used it to another type of defect the volume qty is wrong where in it should be the same from the first one 25973.