The column CC_Int CSIP and CC_Int deliver the same Total? How? The last two number in CC_Int is not in CC_Int CSIP and anyway the total is the same???????? NOG
NOG
8 years agoFrequent Visitor
One is a simple
CC_Int CSIP = DIVIDE(SUM('fact Controller Monthly Report'[Number of interactions]);2)
The other one is a selection of three possibilities depending on what data that is available
CC_Int = if(DIVIDE(SUM('fact Controller Monthly Report'[Number of interactions]);2)>0;DIVIDE(SUM('fact Controller Monthly Report'[Number of interactions]);2);IF([CC_Int Man]>0;[CC_Int Man];[CC_Int Calc Un-w]))
NOG