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.

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.