I have created a table showing opportunity stage, seller name, and countrows of opportunities. On the seller name I have checked off “show items with no data.” When I copy the table and and change it to a pie chart to only show opportunity stage and countrow opportunities, I can no longer see blank. What would be the appropriate measure to create so I can count the total number of blanks?
What I am trying to do is show which sellers have no opportunities for a national vendor.
Hopefully I explained what I am looking for thoroughly. I am new to DAX and struggling to find the measure that would help me.
Thank you in advance for looking at my post.