Forum Discussion
How to calculate without blank
Hello null values usually dont show on visulas and dont get calculated, so im guessing you changed null to a space or empty column? when you have the type of the column as text, blank will be used as a space like so if thats the case then just filter out the "blank" by doing this
Countof = CALCULATE(COUNT(ETA_Table[ETA Grouping]),FILTER(ETA_Table,ETA_Table[ETA Grouping]<>""))kindly use this measure:
perc = [Count ETA]/CALCULATE(COUNT(Table2[ETA Grouping]),FILTER(ALL(Table2),Table2[ETA Grouping]<>""))by the way great work on design just peice of advice, try to create a metric table and put all your measures in it, its easier and more organized you can do that by clicking on "Enter data" tab and just naming the table metrics and after that add metrics to it and you can delete the blnak column
14 Replies
Dear all,
I am using Power BI Desktop, update September 2022.
I need to know how many line of oustanding items that will delivered within this week, next week, next 3 weeks, ans so on.
I group them into:
1w
2w
3w
No PO (purchase order)
But in this column, I have also blank value, which is if the material already received.
How do I calculate ignoring blank, I don't want the blank visualize.
Thank you very much.
Prima IndonesiaHello null values usually dont show on visulas and dont get calculated, so im guessing you changed null to a space or empty column? when you have the type of the column as text, blank will be used as a space like so if thats the case then just filter out the "blank" by doing this
Countof = CALCULATE(COUNT(ETA_Table[ETA Grouping]),FILTER(ETA_Table,ETA_Table[ETA Grouping]<>""))Dear eliasayy,
The solution given to me working well, but then how do I get the percentage except/ignoring the blank?% ETAGroup = [Count ETA]/CALCULATE([Count ETA],ALL(Table2[OWL Type]))
With the above measure, it gave me the wrong result.
And below measure based on your suggestion is working well.Count ETA = CALCULATE(COUNT(Table2[ETA Grouping]),FILTER(Table2,Table2[ETA Grouping]<>""))
Thank you very much.
Prima Indonesia