I need to show in table in PowerBI filtered results based on value of one measure > 30 OR value of other measure > 50 and have no clue how can I do it.
To explain it simple:
SELECT * FROM PRODUCTS WHERE "Parameter1">30 OR "Parameter2">50
But how to implement something like this in PowerBI.
The following recommendations will help you in your SQL tuning process.
You'll find 3 sections below:
SELECT * FROM PRODUCTS WHERE 'Parameter1' > 30 OR 'Parameter2' > 50