Forum Discussion
afaherty
Helper V
Helper VIgnore blanks when calculating %
Hello All, I have researched this for hours but have been unable to resolve it. Any help would be appreciated. I have survey data. Of course, sometimes respondents do not answer every question. ...
Dangar332
Resident Rockstar
Resident RockstarHI, afaherty
use Visual level filter like below image made from your data
in advance filter option choose isnotempty for The class was very helpful column
afahertyHelper V
Helper VThank you, but as I mentioned, that means then that the bars in the graph do not add up to 100%. I would prefer to handle this via DAX.