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
Dear eliasayy,
Is it possible to upload the sample of Excel workbook (16KB or Power BI files (2MB) here. What is the icon should I use?
Thank you
Prima
for normal users like us we cant directly share files on powerbi. so for us to share
you need to upload the file to onedrive dropbox or whatever sharing cloud site and copy the link and share it here
Dear eliasayy,
I am very glad you back again to save me.
Below is the link of Power BI file:
https://drive.google.com/file/d/1GQDxDovBQ-cYTiXqMtUHH3cB40vwM0Di/view?usp=sharing
Thank you very much.
PrimaDear eliasayy,
Below is the link of Excel workbook.
https://docs.google.com/spreadsheets/d/1nCXE6NJJS9IkYXSzJFSmHTHEZPkjpMjh/edit?usp=sharing&ouid=116742594743234602268&rtpof=true&sd=true
Thank you very much
Primano problem now can you please explain what youre trying to achieve? you want the count of eta without blanks to divid over total?