Forum Discussion
double filter for same dimension
Anonymous solution attached.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hi Anonymous, parry2k, hohlick
All of yours solutions are work fine. Thank you for your helps.
I marked 2 solution because their working logic is different.
I continued with Anonymous solution.
I want to ask one more thing in there.
Is it possible to add one more case to Type parameter as "Exclude". It means it must include first material but it should not include second material.
Exclusion should also be possible. You have to add another value for "exclude" in the table where you have given "and" and "or" is listed.
Then accordingly, based on the value of exclusion, add one more IF condition or SWITCH to change the measures accordingly.
Nothing complicated. Writing down the logic/algorithim on paper first and then transferring them to DAX code will help if you have any confusion. Sometimes, our brains are good with pen and paper than on computer when working with logics.😀