I’ve got an issue that I’ve never seen before and can’t quite figure out.
My formula works fine when working on the Power BI Desktop. However, it defaults to the alternate result in the divide formula when I publish it.
Can formulas max out cloud processing power? Could the issue be something else?
I can supply a model if it’s necessary. But, I’m not having issues with the syntax or the result (at least as far as I know).
Here is the formula:
Capacity Utilization % = DIVIDE( [Total Hours for CU], [Avaliable Hours], 1 )
Here are the supporting formulas
Total Hours for CU = CALCULATE( [Total Hours], ALLSELECTED( Items[Item SubGroup] ) )
a. Total Hours = SUM( Production[Total Hours] )
Avaliable Hours = [Count of Line] * [Days Worked] * [Daily Capacity]
a. Count of Line = CALCULATE( DISTINCTCOUNT( ‘Plant & Line’[Line] ), ALLSELECTED( ‘Plant & Line’[Line] ) )
b. Days Worked = [Count of Days] * DIVIDE( [Working Days], 7, 0 )
i. Count of Days = CALCULATE( DISTINCTCOUNT( ‘Date’[Date] ), ALLSELECTED( ‘Date’[Date] ), FILTER( ‘Date’, ‘Date’[Holiday] = “False” ) )
ii. Working Days = SUMX( ‘Plant & Line’, ‘Plant & Line’[Working Days] / COUNT( ‘Plant & Line’[Line] ) )
c. Daily Capacity = SUMX( ‘Plant & Line’, ‘Plant & Line’[Daily Capacity] / COUNT( ‘Plant & Line’[Line] ) )