Forum Discussion
Solved
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
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
Helper VHi 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,
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
- luxpbi
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.
yes sir
you can use like
countrows(filter(table_name,isblank(value)&&country="ind")) and put in card chart
