Forum Discussion
Dynamic Column Metrics
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 TeamIf 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
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
I was worried about that, but I am beginning to think that is the only way. I'm going to have quite a few columns to do this for which is why I was trying to avoid making the measure for each column but maybe that is the only way.