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 troubles calculating percentages with subcategories. See below I would like in the 3rd column to calculate the % over the total net sales, but it's filtered per subcategories. How can I solve that? See below the formulas I used
3rd column: Perc_Total_NetSales = var Totalvalue = SUMX(ALL(ViewReportingSummary[SalesSourceDesc]);
CALCULATE(SUM(ViewReportingSummary[Net_Sales_Value])))
return divide(SUM(ViewReportingSummary[Net_Sales_Value]); Totalvalue)
4th column:Perc_Total_NetSales_Tot = var Totalvalue = SUMX(ALL(ViewReportingSummary[Online Sales]);
CALCULATE(SUM(ViewReportingSummary[Net_Sales_Value])))
return divide(SUM(ViewReportingSummary[Net_Sales_Value]); Totalvalue)
Solved! Go to Solution.
Hi @sophie63,
Please try to modify the 3rd column DAX to below:
Perc_Total_NetSales =
var Totalvalue = CALCULATE(SUM(ViewReportingSummary[Net_Sales_Value]);ALL('ViewReportingSummary'))
return
divide(SUM(ViewReportingSummary[Net_Sales_Value]); Totalvalue)
Best Regards,
Qiuyun Yu
Hi @sophie63,
Please try to modify the 3rd column DAX to below:
Perc_Total_NetSales =
var Totalvalue = CALCULATE(SUM(ViewReportingSummary[Net_Sales_Value]);ALL('ViewReportingSummary'))
return
divide(SUM(ViewReportingSummary[Net_Sales_Value]); Totalvalue)
Best Regards,
Qiuyun Yu
Perfect, that works, thanks a lot!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |