Forum Discussion
filtering a column based on length of string
hi rohit_singh here is the sample. in the filter you can see that ther are 13 blank and 7083 empty. when i cross checked this in postgresql i saw that powerbi shows the percent for empty cells when using blank() and not the percent for null values.
but there is a solution for this that i got with following dax:
NB Cities fields = (CALCULATE(COUNTROWS(individuals),FILTER(individuals,individuals[ind_city] = blank()))/((CALCULATE(COUNTROWS(individuals)))))using COUNTROWS i got both blank and empty values. earlier i was not using countrowsThanks for your help in this rohit_singh
hi rohit_singh here is the sample. in the filter you can see that ther are 13 blank and 7083 empty. when i cross checked this in postgresql i saw that powerbi shows the percent for empty cells when using blank() and not the percent for null values.
but there is a solution for this that i got with following dax:
Solution SageHappy to hear you were able to get the intended result rdvasisht . Kindly mark your answer as the accepted solution for this post to help others as well.