Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous ,

 

Try like

volume qty= CALCULATE(table[defect Count], ALLSELECTED(table))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak its possible to use the code you've given with filter. I need to calculate the defect count and filter the column1 = "ASY"
  CALCULATE(table[defect Count], ALLSELECTED(table))