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...
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.

amitchandak's avatar
amitchandak
Super User
4 years ago

PBIfanatic , Try to +0 to measure and try

sum(Table[Sales]) +0

 

or do that for conditional formatting measure

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.