Not showing blanks in matrix

[Nudo]

I have a table that's created from a venue columns in 4 other tables

I've created it using this DAX formula

Venue Table = DISTINCT(UNION (SELECTCOLUMNS ( 'Lead', "Venue", 'Lead'[Venue__c]),SELECTCOLUMNS ( 'Opportunity', "Venue", Opportunity[Venue__c] ),SELECTCOLUMNS ( 'Lead Instance', "Venue", 'Lead Instance'[Venue__c] ),SELECTCOLUMNS(Event,"Venue",Event[Location])))

This gives me a bunch of options and I only want a couple of main ones and the rest are others so I've created another column using SWITCH case like this

Others = SWITCH(TRUE(),'Venue Table'[Venue]=Venue1,Venue1,'Venue Table'[Venue]="Venue2","Venue2",'Venue Table'[Venue]="Venue3","Venue3",'Venue Table'[Venue]="Venue4","Venue4",'Venue Table'[Venue]="Venue5","Venue5",'Venue Table'[Venue]="Venue6", "Venue6",ISBLANK('Venue Table'[Venue]),"Blank","Other")

This nearly works the problem I'm having is when I put this in a Matrix I can't see a count of ones that are blank when using Others column it works fine when I use Venue column though, I'm wondering what am I doing wrong here? 

Edit: Venue Table[Venue] has a direct relationship many to many to all other Tables venue columns

[Anonymous]

Hi @Nudo ,

//This nearly works. The problem I'm having is when I put this in a Matrix, I can't see a count of ones that are blank when using others column, it works fine when I use Venue column though, I'm wondering what am I doing wrong here? 

Would you mind telling me what fields are in the matrix and where they are placed? 

Power BI doesn't like many-to-many relationships when modeling, this can cause many unexpected results, read this document to see if it is possible to optimize the model.

Many-to-many relationship guidance - Power BI | Microsoft Docs

You can post some images of the expected output or an example file that does not contain private data. These may help you get answers faster.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Nudo]

Hey thanks for the reply

So heres both tables first ones showing the main venue table column and the second one is showing the second column with the switch case

In red is showing expected results, the second column on both tables is the same as the first just fyi the rest are from varying tables. I've just noticed today that the column total is also not picking up any blank values. Guessing this has something to do with it.