Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Expand column and filter

Hello everyone, thank you for your help. I have a source that gets a JSON similar to this: [ { "dataId": 1, "dataName": "Producto A", "labels": [ { "labelId": 101...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago
For example I want to obtain all the products of ALMACEN and the NATURA brand.

Unfortunately there is a disconnect between everyday language and mathematical language. Your example above in math terms would be 

[Label]="Almacen" || [Label] = "Natura"

IE it is an OR statement, not an AND statement.

 

Now - in Power BI you cannot combine filters from different columns into an OR statement. They will always be applied as AND.  And conversely, you cannot filter items from the same column via AND   because that would get you an empty result. 

Note that you can of course override all this with  measures.  But you better be very clear about your business rules and how they translate into math language.