Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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] = " Gross Profit")) / CALCULATE(SUM(POC[Value ($)]), FILTER(POC, POC[Report Param] = " Sales"))) , Sum(POC[Value ($)]))
I need to calculate the Value for Gross Profit in % of Sales as Gross Profit/Sales.
(Logic: Value is Sum of all the values for all Report Parameters except Gross Profit in % of Sales, For Report Parameters except Gross Profit in % of Sales the value is average of the Values)
But my expression is filtering out the Gross Profit in % of Sales from the table, how to resolve this?
any help is appreciated,
thanks
Bhavesh
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |