Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
JWick1969
Helper IV
Helper IV

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 page and it should be getting the volume for that particular month.
Right now it display 171166, the correct value should be 25973 of  volume qty. January.   May i know if i'm missing from my measure of volume qty. could not figure out if this is correct.

measure to get the volume qty

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

sample:
 
sample1.jpg
 
Appreciate the help. 
Thank you.
4 REPLIES 4
amitchandak
Super User
Super User

@JWick1969 ,

 

Try like

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

@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))

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.

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors