Forum Discussion

TuckRhodes's avatar
TuckRhodes
Helper I
2 years ago
Solved

Dynamic Column Metrics

I am trying to recreate the 'Column Quality' Power Query feature in Power BI. For example, I would like to get a null or blank percentage based on a column that the user has chosen from a field param...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi TuckRhodes ,

    The most common way to do this is to create measures for each column similar to the one below and then bind them to the field parameters:

    Column 1 = 
VAR __num_null = CALCULATE(COUNTROWS('Table1'),ISBLANK('Table1'[Column1]))
VAR __num_rows = COUNTROWS('Table1')
RETURN DIVIDE(__num_null,__num_rows) + 0



    The pbix file is attached for reference.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

Ray_Minds's avatar
Ray_Minds
Solution Supplier
2 years ago

Please take look in the below highlighted calculation. You need change with this query. I hope that would be helpful.
Null Percentage =
VAR selected_column = SELECTEDVALUE('Column'[Column Fields])
VAR num_rows = CALCULATE (COUNTROWS(Table1), All(Table1))
VAR num_null = COUNTROWS(FILTER(Table1, ISBLANK(selected_column))))
RETURN DIVIDE(num_null, num_rows)


TuckRhodes's avatar
TuckRhodes
Helper I
2 years ago

Unfortunately, this is still giving me the same result.