Forum Discussion
Building Slicer with DAX
Here is my problem... I have two tables, SKU table joined 'many-to-one' by Supplier_Number with Supplier table. In the SKU table apprear blank supplier numbers, thus when I create a Slice...
amitchandak
Super User
Super UserAnonymous , As there is blank on join column, You will get blank even in slicer. You can use visual level filter and remove blank .
Also in measure or in page/visual you can remove blank
Calculate(count(SKU[Group]), not(isblank(SKU[Supplier_Number])))
amitchandak thanks for your reply.
Unfortunately, this was not exactly what I was trying to achieve. Apologise, if my explanation was misleading.
Basically, I want to see something like below. Hopefully picture speaks for itself.