Here it is. Have a look at Screenshot and attached. First you need to PIVOT your data and then you need the Calc as below which you will drag to Filter and SET TRUE.
If it Helps, pl mark it Helpful and CORRECT to close Thread.
Prod 1 Select
Select One output all.twbx 25.7 KB
Thanks Deepak . Can you help me understand how you were able to put measures prod1..prod4 in the dimension prod?