Forum Discussion

PBIfanatic's avatar
PBIfanatic
Helper V
4 years ago
Solved

Missing filter context

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 IDSales
12200
122500
1222121

 

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

Product IDSales
11 
12200
122500
1222121
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.

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

3 Replies

    • PBIfanatic's avatar
      PBIfanatic
      Helper V
      4 years ago

      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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.