Forum Discussion
kumar_din12
8 years agoFrequent Visitor
how to filter use count function blank values in power bi desktop
hello sir by using the only count function. my my requirement is :- like ind = 3 & uk = 1 Please find the below attatchnment sir thanks and regards P.dinesh kumar
- 8 years ago
This is the formula:
Count blanks = COUNTBLANK( Table1[value] )
And this is the output:
If this is what you are looking for, please mark the answer as accepted.
Regards.
luxpbi
Helper V
8 years agoHi kumar_din12,
I don't really understand what do you want to do.
Do you want to count the number of blank values?
If so, you can do it with
COUNTBLANK()
Regards,
- kumar_din128 years agoFrequent Visitor
hello sir
Sorry for the trubble to you
vender value country b 110 ind c ind d 105 ind e ind f 130 ind g 135 ind h 140 ind i ind j 200 uk k 250 uk l 210 uk m uk n uk o 310 uk p 410 uk By using the count function
my requirement is filter the blank values Like
Ind = 3
uk =2
this is my out put sir
- luxpbi8 years ago
Helper V
This is the formula:
Count blanks = COUNTBLANK( Table1[value] )
And this is the output:
If this is what you are looking for, please mark the answer as accepted.
Regards.
- kumar_din128 years agoFrequent Visitor
yes sir