Power BI formulas help

[Ashu27]

Hi Experts , we are building a powerBI dashboard for our data quality dashboard from the daily data quality reports out of Azure. We are doing extensive DQ checks such as null check, character validation check ,outlier check and so on. We need to show fields like total count,valid count,error count,error percentage, and we need these non additive fields to show in range of dates,let's says in between no of days, week, month and yearly total summaries. We are using formular such as 

1.Error Percentage

Error_Percentage = DIVIDE( [Error_Count], [Total_Count], 0 ) * 100

2. Valid Percentage

Valid_Percentage = DIVIDE( [Valid_Count], [Total_Count], 0 ) * 100

3.Null Validation Metrics

Null_Error_Percentage = VAR NullErrors = CALCULATE( [Error_Count], DataQualityReport[Validation_Type] = "Null Validation" ) VAR NullTotal = CALCULATE( [Total_Count], DataQualityReport[Validation_Type] = "Null Validation" ) RETURN DIVIDE(NullErrors, NullTotal, 0) * 100 // Null check pass rate Null_Pass_Rate = 100 - [Null_Error_Percentage] 

and similarly we are doing the same for character limit check etc. Please suggest is it the right approach or formulas are correct to give correct results.

[bhanu_gautam · Accepted solution]

@Ashu27 Your approach to calculating error percentage, valid percentage, and null validation metrics using DAX formulas in Power BI seems correct. The formulas you provided are standard ways to calculate these metrics and are commonly used in data quality analysis