Missing filter context

[PBIfanatic]

Hi,

I have a set of products as shown , there is conditional formatting on these products based on a measure - count(Sub products)

Product ID

11

12

122

1222

21

When I join this to the sales table to get the sales data I get the below table

Product ID	Sales
12	200
122	500
1222	121

With show no data I get this, but I lost the conditional formatting for product 11 and 21

Product ID	Sales
11
12	200
122	500
1222	121
21

Is there a way to force that? If I addin the meausre for sub product into the table I see the highlight but I dont want to addthis in. 

Is there a way to force the filter context? thanks for your help.

[Anonymous · Accepted solution]

Hi @PBIfanatic ,

I have built a data sample,as shown below, Table1 and Sales table have a relationship based on a Product Name:

And I created a measure to simply calculate the count of each Procuct.

Measure = 
var _count=CALCULATE(COUNTROWS('Table1'),ALLEXCEPT(Table1,Table1[Product ID]))
return 
SWITCH(_count,4,"light blue",3,"Red", 2,"light green",1, "Grey")

But sorry for that I could not reproduce your issue:

So please provide me with more details about your table  or share me with your pbix file after removing sensitive data.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@PBIfanatic , Try to +0 to measure and try

sum(Table[Sales]) +0

or do that for conditional formatting measure

[PBIfanatic]

Hi @amitchandak 

 thanks for your reply but that didnt work. it has forced 0 to lot of other Products.

The products I had shown was based on few filters on the report page. 

Now all those filters are ignored, and shows all products and  0's against the ones that doesnt have sale amount.