Dynamic Calculation Group for Data Quality Validation Based on Selected Columns

[Sonicks]

I would like to create a Calculation Group in my Power BI model that allows me to dynamically apply a specific measure based on the selected column. Specifically, I want to implement a data quality rule that checks whether a column contains blank values, etc, etc.

The idea is as follows:

• The Calculation Group should include a measure that checks if a selected column contains blank values.
• I want to repeat this logic for multiple columns in the same table, where each Calculation Item in the group corresponds to a specific column.

My goal is to make this dynamic and reusable so that users can choose which column they want to validate in the report environment.

Is this possible? If yes, how can I implement this using Tabular Editor 3 and Power BI?

[VahidDM]

Hi @Sonicks 

Yes, it's possible. You can create a Calculation Group in Tabular Editor 3 where each Calculation Item corresponds to a specific column you want to validate. Here's how:

1. Create a Calculation Group named, for example, "Data Quality Checks".

2. Add a Calculation Item for Each Column:

   • For each column, create a Calculation Item with an expression like:

COUNTROWS(FILTER('YourTable', ISBLANK('YourTable'[ColumnName])))

1. • Replace 'YourTable'[ColumnName] with the actual table and column names.

2. Implement in Power BI:

   • In your report, add a slicer using the names of the Calculation Items.
   • When a user selects a column from the slicer, the measure will display the count of blank values for that column.

This approach allows users to dynamically select columns to validate for blank values within the report.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn|Twitter|Blog |YouTube 

[Sonicks]

This, unfortunately, is not what I am looking for.

What I am looking for is a way to enter any column as a key in the measure.

In short, a dynamic measures containing a dynamic check over all the columns in my table. Without having to create a separate measure/item for each column.

[Sonicks]

This, unfortunately, is not what I am looking for.

What I am looking for is a way to enter any column as a key in the measure.

In short, a dynamic measures containing a dynamic check over all the columns in my table. Without having to create a separate measure/item for each column.