Forum Discussion
How to avoid filtering in my expression ?
Hello, I have the expression as shown below; Test Value = IF(SELECTEDVALUE(POC[Report Param]) = "Gross Profit in % of Sales", (CALCULATE(SUM(POC[Value ($)]), FILTER(POC, POC[Report Param] = ...
Can you provide sample/example data? Having a bit of a hard time understanding what you are going for here. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490