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
Super User
5 years ago

Anonymous ,

 

Try like

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi, Already found the root cause why its is not working correctly when I do the filtering. This is what I found In filter on visual I have excluded the empty defect and also perform top 10 defect. So removed these filters and the volume is displayed correctly. However, how can I perform a top 10% that will not affect the values and also the empty defect will ot be displayed in the visual?

 

Thank you.