Forum Discussion
Card visualization for % values
Create a measure
Measure = DIVIDE(COUNTROWS(FILTER(Table, Table[Column1] = "female")), COUNTROWS(Table))
Format the measure as a percentage. Put it on a card.
You can't compare a string to a boolean.
Table[Column1] <> ISBLANK(Table[Column1])
If you do an explicit comparison with blank(), you need to understand that 0 and empty string will also be blank.
That's ok if you understand your data.
Best practice is to use ISBLANK, I think you can write
COUNTROWS(FILTER(Table4, not ISBLANK(Table4[Column1])))but please test.
Create a measure
Measure = DIVIDE(COUNTROWS(FILTER(Table, Table[Column1] = "female")), COUNTROWS(Table))
Format the measure as a percentage. Put it on a card.
Thank you, this helps a lot. I am trying to remove the blanks also. However , I am getting an error with this edit:
Measure = DIVIDE(COUNTROWS(FILTER(Table, Table[Column1] = "female")), COUNTROWS(FILTER(Table, Table[Column1] <> ISBLANK(Table[Column1])))
Any ideas why?
thanks
You can't compare a string to a boolean.
Table[Column1] <> ISBLANK(Table[Column1])
If you do an explicit comparison with blank(), you need to understand that 0 and empty string will also be blank.
That's ok if you understand your data.
Best practice is to use ISBLANK, I think you can write
COUNTROWS(FILTER(Table4, not ISBLANK(Table4[Column1])))but please test.thank you for the solution and explanation!