Bridging table-hide item with no data

[Anonymous]

I have two different sets of Data (1. Payroll cost 2. Demographic).

I am trying to create a table showing dept. no of headcount. average cost.

Example.

Department (From Bridging Table)	Headcount (From Demographic)	Average Employment Cost (From Payroll Cost)
Human Resource	2	100
Finance	10	150
Customer Service	5	120

I have created a bridging table for Department by creating a table based on the distinct value of Department in the demographic table. Relationship is one to many single direction from Demographic["Department"]to bridging table["Department"] and one to many single direction from payroll["Department"] to bridging table["Department"].

However, when i create visualization it is always showing all departments despite not having any data for headcount and average employement cost.

Example (on this month, there are no cost and no headcount in finance department, yet "Finance" is still reflected in the Department column.-show item with no data is not selected)

Department (From Bridging Table)	Headcount (From Demographic)	Average Employment Cost (From Payroll Cost)
Human Resource	2	100
Finance	0	0
Customer Service	5	120

Ideal State with the scenario.

Department (From Bridging Table)	Headcount (From Demographic)	Average Employment Cost (From Payroll Cost)
Human Resource	2	100
Customer Service	5	120

Please Advice.

Thank you.

[amitchandak · Accepted solution]

@Anonymous , need to look at the formula, is converting blank to 0. Ideally, it should be blank where there is not data

Are you using like

Meausre = count(Table,Table[A]) +0

Or using this option

Another option is filter 0 using visual level filter

[Anonymous]

Hi @amitchandak, thanks a lot it work. I was using measure = +0 , i removed the +0 and the unnecessary information is gone.