Hi,
I have tried several differnet methods to achieve this. But none have come up with result I am looking for. The % column is the issue. It needs to be Actual / Predicted, with the correct figure in the % column. Customer A Product B 14805 % should be 15% or thereabouts.
The measures I have so far tried are:
% = divide(sumx(Sales,'Sales'[Actual by serial number]),CALCULATE(sum('Usage'[2022 Achievable Revenue]),ALLEXCEPT(Usage,Usage[Customer],Usage[Product Group],Usage[Serial number])))
% = divide('Sales'[Actual by serial number],CALCULATE(sum('Usage'[2022 Achievable Revenue]),ALLEXCEPT(Usage,Usage[Customer],Usage[Product Group],Usage[Serial number])))
Actual v Achievable = divide('Sales'[Actual by serial number],sumx('Usage','Usage'[2022 Achievable Revenue]))
Actual v Achievable = divide(sumx('Sales','Sales'[Actual by serial number]),
calculate(sumx('Usage','Usage'[2022 Achievable Revenue]),ALLSELECTED(Usage[Serial number])))
where Predicted is 'Usage' and Actual is 'Sales'
Helpful resources
Power BI Monthly Update - August 2025
Check out the August 2025 Power BI update to learn about new features.
Fabric Community Update - August 2025
Find out what's new and trending in the Fabric community.
