Percentage lower than a certain value

[Anonymous]

What would be the dax/ syntax to create a measure to count how many values are below 0.7 and divide it by the total number of rows??

Thanks!!

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

calculate(countrows(Table), filter(Table, Table[Data Quality] <.7))

[Anonymous]

I am now tryign to create a new measure to divide the number of failed scans (measure) by the count of data quality. I tried this but it is not working? 

Measure = SUMX('Mine Data ',[Failed Scans]/COUNT('Banpu Data '[Data Quality]))

Thanks!

[harshnathani · Accepted solution]

Hi @Anonymous ,

Check if this works.

Measure = DIVIDE( [Failed Scans], COUNT('Banpu Data '[Data Quality]))

Regards,

Harsh Nathani

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

calculate(countrows(Table), filter(Table, Table[Data Quality] <.7))