Forum Discussion
Advanced Filtering in Pivot Tables
If I'm not mistaken, the best practice, insofar as Pivot Tables goes, for implementing logical OR conditions and other advanced nested filtering is by adding a column (that performs the true/false te...
In this case yes, you can't create calculated column/field on client side. But you may create MDX Calculated Measure or MDX Calculated Fields, that is under OLAP tools. On my file connected to Power BI dataset sample calculated measure looks like
You may google for more details.