Forum Discussion
calculate distinct count filter by not zero
Community ChampionYou will want to use something like
FILTER(Tab, NOT(ISBLANK(Tab[blankable column])
as a parameter on CALCULATE.
Also, be aware that sometimes a value is BLANK, sometimes it is just ""
Hope this helps.
David
Thanks @ dedelman_clng, but it did something weird with the count of the column or did I not get the script right?
- dedelman_clng
It looks like you're trying to create this as a calculated column instead of a measure. Try recreating as a measure and build a table visual instead of using the data preview.
Other than that we would need to see more of your model, data, etc to help troubleshoot further. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490