09-30-2019 12:58 PM
You may use CounfIf function.
So if you are counting the values in column A which are not zeros, you may try...
Or if you want to count in the Pivot Table itself, while inserting the Pivot Table, check the box for "Add this data to the Data Model" and then create a Measure to count except zeros using of the following DAX formula.
by patdj182 on May 06, 2020
by appreciate_help on January 16, 2020