I need to do a =COUNTIF() ">0" on an entire column in a pivot table (I can't use a range because the number of rows changes in my table). The column in question is a Measure in PowerPivot. What is the appropriate syntax?
1. Is there some more sophisticated way to do what I'm trying to accomplish with DAX?
2. What is proper etiquette for this forum? Do I just open a new post or is there some way to move or reference this one?
I think I can make that work for me. What I did is create the measure you showed me and added it to the pivot table. It created a column of 1's and 0's and produced the correct total. Since the cell where I want to show the total is outside the pivot table, I used GETPIVOTDATA on that column and it shows the number I'm interested in. Then I hid the column I added.
Does this sound like the best way to accomplish this? Thanks so much for your help.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.