I am a rookie in PBI. I want to rank customer names by sales. That sounds like an easy question. But I have to exclude certain customer names in ranking (particularly, i have to exclude all customrers with blank names in my dataset).
I tried to filter the table and then do the ranking. It is not working for me.
Thanks for help!
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Thanks for looking into this.
Here is a mock dataset for my purpose. I want to rank the Customer Name by Total Sales; however, I want to EXCLUDE the following two types of Customers in my ranking:
Sales Order Num
You may refer to the following post.
Unfortunately, the post does not apply to my situation.
The post is ranking the club but excluding club names which have blank YOY values.
My situation is more like ranking the club but excluding the club names that are BLANK (let's call these clubs anonymous clubs). These anonymous clubs actually have YOY values.
I tried to modified the formula in the post to my situation and it is not successful.