Forum Discussion
Dynamic Calculation Group for Data Quality Validation Based on Selected Columns
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:
-
Create a Calculation Group named, for example, "Data Quality Checks".
-
Add a Calculation Item for Each Column:
- For each column, create a Calculation Item with an expression like:
COUNTROWS(FILTER('YourTable', ISBLANK('YourTable'[ColumnName])))
-
- Replace 'YourTable'[ColumnName] with the actual table and column names.
-
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
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.
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.
