Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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:
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?
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:
COUNTROWS(FILTER('YourTable', ISBLANK('YourTable'[ColumnName])))
Implement in Power BI:
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.
User | Count |
---|---|
64 | |
59 | |
47 | |
33 | |
32 |
User | Count |
---|---|
84 | |
75 | |
56 | |
50 | |
44 |