Forum Discussion
Distinct count subtotal
Hello all
Please see my data v-frfei-msft amitchandak
I have highlighted in my power pivot the column data required and the current measure being used. The measure shows the value 1 against any sales person who has completed a review , this has been achieved by filtering for a distinct count of any value above zero and displaying how many of these values exist in each row, so any number that is not 0 in any row will return 1.
I would like to subtotal this for each column so that the measure for the sales people group should show 2 as there are 2 people in this group that performed a number of reviews rather than zero. The column highlighted in green represents the results i wish to see
Can anyone help?
- v-frfei-msft6 years agoCommunity Support
Hi superDAX ,
What does your measure look like? Could you please share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.